on 04-08-2015 12:39 AM
Hi Team,
I have an issue, where i want to grant a select on particular view in SYS schema to a user. Now the problem is that SYS user would be deactivated right is there any alternate way i can grant select on tables existing in SYS schema or it is not possible?
I tried searching information but couldnt find
Could not execute 'grant select on <table_name> to <user>' in 21 ms 157 µs .
SAP DBTech JDBC: [258]: insufficient privilege: Not authorized
This thread talks about HANA SUPPORT ROLE but not about SYS schema.
http://scn.sap.com/thread/3441582
Wanted to understand if there is a workaround?
Hi,
Select on SYS schema is only available to SYSTEM user and it cannot grant the access to other users.
SYS is a main schema in HANA so I don't think SAP wants anyone to do anything with this schema due to which only SYSTEM user has select access to this schema
If you want to grant select access on SYS schema then you can grant SAP_INTERNAL_HANA_SUPPORT role to the user
Regards,
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SAP_INTERNAL_HANA_SUPPORT helps to get select access but it seems this role can only be assigned to 1 user at a time.
SAP HANA 2.0 SPS 05 Rev 55
Could not modify user 'XXXXXX'. SAP DBTech JDBC: [456]: not allowed for this role: grant to more than the preconfigured number (1) of users at a time
This is just in case if anyone is planning to assign to multiple users.
Also - Alert "Granting of SAP_INTERNAL_HANA_SUPPORT role" (id 63) - Low priority alert will be generated for this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.