#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2004
    Location
    Mississauga, Canada
    Posts
    5
    Rep Power
    0

    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
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2011
    Posts
    3
    Rep Power
    0
    if the abc user have DBA privileges, you can give the GRANT PRIVS
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2004
    Location
    Mississauga, Canada
    Posts
    5
    Rep Power
    0
    Originally Posted by mukris
    if the abc user have DBA privileges, you can give the GRANT PRIVS
    Thanks for the recommendation
    Since I had to get this done a while ago, I created a separate process which logs into the other (xyz) schema and then grants the privilege itself.
    A bit of a pain in the ***, but not too bad

    I'll give your recommendation a try, but just to satisfy my curiosity
    The project in question is already tested and modifying it would require more testing from QA, all they do is complain about resources, so that won't fly

IMN logo majestic logo threadwatch logo seochat tools logo