on 08-13-2018 9:58 AM
Hi everyone,
I am using HANA Studio to access one of our HANA DBs (version 1.00.112.07.1477423516 running on a virtual SUSE Linux Enterprise Server 11.2). I currently require additional privileges such as CREATE PROCEDURE or CREATE R SCRIPT that the database administrator is giving me. However, after every database/server restart these privileges are lost in the morning! Among the 'CREATE %' privileges only CREATE ANY remains. Checking with
select * from GRANTED_PRIVILEGES
where privilege like 'CREATE %'
order by grantee;
it looks like this
GRANTEE_SCHEMA_NAME;GRANTEE;GRANTEE_TYPE;GRANTOR;OBJECT_TYPE;SCHEMA_NAME;OBJECT_NAME;COLUMN_NAME;PRIVILEGE;IS_GRANTABLE;IS_VALID
?;JENDERKA;USER;SYS;SCHEMA;JENDERKA;?;?;CREATE ANY;TRUE;TRUE
The same privileges of other users are still there, however. They look like
GRANTEE_SCHEMA_NAME;GRANTEE;GRANTEE_TYPE;GRANTOR;OBJECT_TYPE;SCHEMA_NAME;OBJECT_NAME;COLUMN_NAME;PRIVILEGE;IS_GRANTABLE;IS_VALID
?;KUBICKA1;USER;SYSTEM;SYSTEMPRIVILEGE;?;?;?;CREATE R SCRIPT;FALSE;TRUE
Do you have an idea what might cause this behaviour?
Regards,
Marcus
Please check this SAP Note
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.