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