#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Location
    Colombo
    Posts
    3
    Rep Power
    0

    Oracle Object Rights


    Pls. Help me to grant object previlege to a user. I've logged in to oracle 8i, using an account, which has DBA rights. But it will give me an error "ORA-01031 Insufficient Previleges". System previlege can grant. what am I supposed to do?
    Last edited by Lilantha; January 22nd, 2004 at 01:45 AM.
  2. #2
  3. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    305
    Rep Power
    11
    To grant a system privileges, you must either have been granted the system privileges with the ADMIN OPTION or have been granted GRANT ANY PRIVILEGE system privilege.
  4. #3
  5. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    305
    Rep Power
    11
    You can grant object privileges users those are created by the same user (with DBA privileges). But you cannot grant the object privileges to other users those are created by different DBA user.
    For example look at the following tree :

    SCOTT
    |
    --------------------- USER1
    |
    --------------------- USER2
    |
    --------------------- USER3
    ACCOUNTS
    |
    -------------------- ACC1
    |
    -------------------- ACC2

    The SCOTT user can grant the object or system privileges to pnly user USER1,USER2,USER3 not to ACC1, anf ACC2 because these users are created by different user i,e ACCOUNT.

    Regards
  6. #4
  7. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    305
    Rep Power
    11
    No, there is nothing wrong with your configuration. Oracle does not allow you to grant the objects privileges, hold by the other users. Only users who are the owner of that objects, suppose to grant the priviliges of thier objects to other users. For example:

    If System/Manager user wants to grant select priviliges on emp table hold by the Scott/tiger, cause to generate the 'insufficient privileges' error message.
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Location
    Colombo
    Posts
    3
    Rep Power
    0
    Hi shafique,

    I've tried that way and it really works....Many thanks.. And I hope you will help me to solve this also.

    In my database even SYS or SYSTEM canít grant other user's object privileges. Is it the correct way or is it my configuration problem?
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2004
    Location
    Colombo
    Posts
    3
    Rep Power
    0
    great...thanks for the reply.

IMN logo majestic logo threadwatch logo seochat tools logo