insufficient privilege: Not authorized while assigning schema to object privilege

[Former Member]

Hi,

In my trial HCP i have created two user usr01 & usr02 and performing below activities:

i) login to trial HCP with SYSTEM user.

ii) assigning schema usr02 to user usr01

iii) while saving im getting below error

404 - Granting privilege 'SELECT' on SCHEMA 'usr02' failed: insufficient privilege: Not authorized

my requirement is to assign object privilege of usr02 schema to user usr01. could anybody please let me know what im missing here.

Thanks

[former_member514516]

I am also encountering the same issue.. Has anyone been able to resolve this?

[former_member221863]

Hello Sudhanshu,

The owner of the schema can then grant permissions to other users or schemas

Regards

Ganesh Vattamwar

[Former Member]

Hello Ganesh,

Well, user usr01 is owner of schema usr01 and user usr02 is owner of usr02 schema. im logging with SYSTEM user so hoping to assign object privilege of usr02 schema to user usr01. Shouldn't it possible via. user SYSTEM?

Thanks

[former_member221863]

Hi Sudhanshu,

As you have stated that the owner of the schemas is not SYSTEM and the system user will not have any permissions until you give this permissions to the system user like any other user.

So, only the owner of the schema can grant the permissions to other users or the user having such permissions to grant to others.

Hope this answers your question.

Regards

Ganesh Vattamwar

[Former Member]

Thanks Ganesh. my understanding was that SYSTEM user have access to all schemas. so as per your guggestion usr01 can grant its schema to any other user by simple GRANT command. Im anyway checking on this. Thank you for your suggestion.

[former_member221863]

Hello Sudhanshu,

Could you please do the following steps and let us know who is the owner of the schema " usr02" and "usr01"?

1. login to trial HCP with SYSTEM user.
2. execute the select statement "Select * from schemas" using the system user.

RegardsGanesh Vattamwar

[Former Member]

Hi,

Please advise on this if any.

Thanks