on 01-09-2013 8:23 AM
Hi,
I am trying to create role with user SYSTEM and while addind SQL priveleges, i added REPOSITORY_REST and selected "EXECUTE"
but while adding _SYS_BI and _SYS_BIC I am getting error: "_sys_bic object doesn't have assigned privelege". Screenshot attached below.
By default this user will have full access but I think some priveleges are deleted for the user SYSTEM.
Could you please let me know what privelege i need to add for this user.
SAP HANA studio version I am using is 1.0.38.
Regards
Raj
Hello raj,
For the system/non-admin user, you need not to add _SYS_BI and _SYS_BIC in the SQL priviledge. By default, user is having all the access to these tables.
If user is having Modelling role under Grnated roles then you need to add the same in SQL Priviledge beacuse these schema having the information regarding all modelled views.
Hope is is helpful.
Regards,
Neha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.