Skip to Content
0

insufficient privilege: Not authorized while assigning schema to object privilege

Mar 26, 2017 at 10:22 AM

63

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

sudhanshu sharma Mar 27, 2017 at 02:39 PM
0

Hi,

Please advise on this if any.

Thanks

Share
10 |10000 characters needed characters left characters exceeded
Ganesh Vattamwar
Mar 28, 2017 at 03:43 PM
0

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
Share
10 |10000 characters needed characters left characters exceeded
Ganesh Vattamwar
Mar 28, 2017 at 03:44 PM
0

Hello Sudhanshu,

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

Regards

Ganesh Vattamwar

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

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.

0