Revoke of Roles with Grantor SYS

[stefanmirkowski]

Hello, everyone,

how can I remove roles from a user that were assigned by the user SYS?

I get the message "SQL (258) - insufficient privilege: cannot revoke roles granted by user 'SYS'".

I understand the message but there must be a way to remove the roles anyway.

Thank you for a support

[stefanmirkowski]

Hi Michael,

yes i tried that. From the Hana Studio and from the Hana Cockpit. Then the message comes

"Could not execute 'REVOKE "ZSTEST2" FROM ******** GRANTED BY SYS'"

"SAP DBTech JDBC: [258]: insufficient privilege: cannot revoke roles granted by user 'SYS'"

[Cocquerel]

Hello,

did you try the following syntax with "grantor"='SYS' ?

REVOKE <role_name>,... FROM <grantee> [ GRANTED BY <grantor> ] 

see https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20fc91cb75191014ac15eb4...