on 05-17-2016 12:47 PM
Hi All,
I am working on creation of Catalog Roles. And I need to add the application privilege
sap.hana.admin.cockpit.sysdb::WidgetAccess:sysdbadmin | |
|
to a catalog Role. (I am not talking about repository roles)
and below syntax
GRANT sap.hana.admin.cockpit.sysdb::SysDBAdmin to ZROLE does not work.
For sure something in the syntax is missing, but I am not sure what is correct.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There may be a way of finding the exact SQL in which Studio uses.
So you say the system view works fine, what I would recommend to do it to activate the SQL Trace, then proceed and grant the application privilege view the Studio navigation bar, then deactivate the trace. Open the trace file and check what exact SQL the Studio used to grant the privilege. This should work in theory.
https://help.sap.com/saphelp_hanaplatform/helpdata/en/f1/b28c0904cd4b70bebcfa187831b30f/content.htm
Guys thanks for your valuable inputs, if not exact, still they pointed me to the right direction.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
pay attention to quotes before and after the privilege name
' "sap.hana.admin.cockpit.sysdb::WidgetAccess:sysdbadmin" '
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.