Skip to Content

insufficient privilege: Not authorized while assigning schema to object privilege

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 27, 2017 at 02:39 PM

    Hi,

    Please advise on this if any.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28, 2017 at 03:43 PM

    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
    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28, 2017 at 03:44 PM

    Hello Sudhanshu,

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

    Regards

    Ganesh Vattamwar

    Add comment
    10|10000 characters needed characters exceeded

    • 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.