on ‎2021 Nov 18 5:58 AM
It depends on how the analytic privilege was created, the command varies.
1. if the analytic privilege was created from Content -> <package> -> Analytic Privileges (in HANA Studio)
[GRANT]
CALL GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE ('<analytic_privilege>','<user or role>')
[REVOKE]
CALL REVOKE_ACTIVATED_ANALYTICAL_PRIVILEGE ('<analytic_privilege>','<user or role>')
2. if the analytic privilege was created by command "CREATE STRUCTURED PRIVILEGE..."
[GRANT]
GRANT STRUCTURED PRIVILEGE <privilege_name> TO <grantee>"
[REVOKE]
REVOKE STRUCTURED PRIVILEGE <privilege_name> FROM <grantee>
If you are not sure how the analytic privilege was created, you could check the owner of it.
In general, if the analytic privilege was created from Content -> <package> -> Analytic Privileges (in HANA Studio), the owner of the analytic privilege is _SYS_REPO.
In other cases, the owner could be a normal DB user.
You can check the owner via SQL: select * from ownership where OBJECT_NAME like '%<AP name>%';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
More information for reference.
Prerequisites for Granting and Revoking Privileges and Roles
Stored Procedures Used to Grant/Revoke Privileges on Activated Repository Objects
GRANT
Statement (Access Control)
GRANT STRUCTURED PRIVILEGE <privilege_name> TO <grantee>
REVOKE
Statement (Access Control)
REVOKE STRUCTURED PRIVILEGE <privilege_name> FROM <grantee>
Hello.
CALL GRANT_ACTIVATED_ANALYTICAL_PRIVILEGE ('<analytic_privilege>','<user or role>') seems to work fine.
However, due to deprivation of authority, changing GRANT to REVOKE and executing it seems to result in an error.
CALL REVOKE_ACTIVATED_ANALYTICAL_PRIVILEGE ('<analytic_privilege>','<user or role>')
If you deprive a privilege, do you have any necessary privileges for the user performing the deprivation?
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.