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

Related questions

4 Answers

  • Posted on Mar 27, 2017 at 02:39 PM

    Hi,

    Please advise on this if any.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 02, 2019 at 02:26 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.