cancel
Showing results for 
Search instead for 
Did you mean: 

HANA user privileges disappear after system restart

0 Kudos

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

View Entire Topic
HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Please check this SAP Note

0 Kudos

Thanks a lot Hakan! We'll try the suggested solutions in the SAP Note.