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'"