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

    Unanswered: Schema Permissions

    Hi,

    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
    Location
    Liverpool, NY USA
    Posts
    2,509
    Only the owner of a schema can issue a grant on an object in their schema. Not even SYS can do it.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    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
    Posts
    623
    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: http://www.oracle.com/pls/tahiti/tah...?section=74141

Posting Permissions

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