cancel
Showing results for 
Search instead for 
Did you mean: 

Read & Write access for HANA DB users

krishnamohan_corp9
Participant
0 Kudos

Hello,

can any one please tell me if there are tables in my HANA database , How can we grant read & write access in hana admin console for hana user to access these tables.(What kind of access we need to give it to that user)?

any help with the screen shots will be appreciated

Regards

Krishna mohan

Accepted Solutions (1)

Accepted Solutions (1)

muthuram_shanmugavel2
Contributor
0 Kudos

Hi krishna,

1. Open the User whom you want to give Privilege and Go to Object Privilege Tab.

2. Add The Table and Select It.

3. Enable "SELECT", "INSERT", "UPDATE" AND "DELETE" Checkbox and Execute it.

Now this user also have READ/WRITE Privilege for your Table.

Regards,

Muthuram

Answers (4)

Answers (4)

former_member212236
Active Participant
0 Kudos

Hello Krishna,

Muthuram's response is the answer for your question.

As said my Martin, ensure that you assign the package privileges too because in case the package privilege had got Root Package in it then the user would be to create and delete any package in the Content folder which I hope you don't want.

Kindly close the thread if you had got the answers.

Regards,

Vinoth V

Former Member
0 Kudos

Hello Krishan,

please don't forget to assign the corresponding package privileges, too.

Best regares

Martin

AtulKumarJain
Active Contributor
0 Kudos

Hi Krishna,

You have to provide DML operation to schema so user can access the all the tables in that schema.

BR

Atul

yakcinar
Active Contributor
0 Kudos

Hello Krishna,

You can use CONTENT_ADMIN role.

And check security administration guide for the details.

Regards,

Yuksel AKCINAR