Hi everyone, I need to grant object privileges to a user but I'm not the owner of the schema. I've tried doing it with the System user but I can't either. My long shot was using the Sys user (other than System) but it is deactivated and there is no way I'll be able to activate it with my user.
Is there any way I grant that privilege to a user? I can't ask the owner of the schema to do that because she resigned today... and I don't wanna change the pwd of her DB user.
I know that at some point I'll need to create a new DBAdmin user and create a backup of those schemas because when the SAP user of my colleague be deleted, it'll delete the Hana user and the DB user with all of the objects, roles and privileges created and granted with it.
I'm totally new at this... I have only a basic knowledge of SQL security. This is gonna be my responsibility and from now I want to get the things done in the right way, so any further help that you can give me will be well taken.
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.