Hello,
We have a SAP HANA (Web IDE) environment on CAL where we defined a model a while ago. In the meantime the schema user account was deactivated, and our SYSTEM user doesn't have the privileges other than the standard SELECT, INSERT, UPDATE and DELETE without grant option. Our SYS user is in a deactivated state as well, and the XSA_ADMIN cannot grant other users any privileges on that schema. The users don't even have privileges to use GRANT_CONTAINER_SCHEMA_PRIVILEGES.
We tried going through HANA Cockpit like shown in https://community.sap.com/t5/technology-q-a/how-to-activate-a-user-from-user-management-of-sap-btp-h... but we can't see the Activate button. SQL with the admin option in Web IDE and connecting through DBeaver with the SYSTEM user return "insufficient privileges". What are our options to get admin rights or give other users grants on the schema? Alternatively, how can we activate the schema or the SYS user?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.