Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010

    Unanswered: Schema Permissions


    I have an automated process which runs on an Oracle 8i database server as user abc.
    This process creates views/tables in other schemas, on the same database server, which point to objects owned by the abc user.

    The issue I'm getting is that when I try to execute GRANT SELECT ON xyz.view123 TO PUBLIC as the abc user, I get an insufficient privileges.
    I should add that the abc user created the xyz.view123 table/view.

    What grants/priviliges or whatever do I have to do to the abc schema?

  2. #2
    Join Date
    Jun 2004
    Liverpool, NY USA
    Only the owner of a schema can issue a grant on an object in their schema. Not even SYS can do it.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Nov 2003
    Provided Answers: 8
    Quote Originally Posted by beilstwh View Post
    Only the owner of a schema can issue a grant on an object in their schema.
    Or someone who has the "GRANT ANY OBJECT PRIVILEGE" privlege
    Not even SYS can do it.
    In my installation of Oracle 11.2, SYS does have that privilege (and the DBA role)

  4. #4
    Join Date
    Mar 2007
    I think that "select any table with admin option" should allow it.
    For other action(s), it would be "<action> any <object> with admin option" (if it exists).
    You may study all available system privileges in Oracle documentation:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts