DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: insufficient privileges

  1. #1
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi there

    I am trying to grant insert, update & delete object privileges to a table using the following command

    GRANT INSERT, UPDATE, DELETE ON SYSADM.PS_ORD_TEST TO WEBROLE;

    however I keep getting the error "ORA-01031: insufficient privileges"

    I am performing the action using my own userid 'TONNERA', which has DBA rights, the tables belong to another user 'SYSADM'.

    I have tried to alter my session to the tables schema, the alter works but I still get the error.

    Any assistance would be great

    Many thanks

    Alison

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot grant privilege to another user objects that doesnt belong to you, even you are dba

  3. #3
    Join Date
    Aug 2000
    Posts
    236
    I think that to grant object privileges to other users, only the owner can grant them.

    Login as sysadm and then grant the privileges.

  4. #4
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Many thanks for your information, I thought that this was the case, my senior DBA won't give me access to the SYSADM password...

    I guess he will just have to do it himself.

    Cheers

    Allie

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    He might still decide to delegate this right to you, by isuing:

    GRANT SELECT, INSERT DELETE, UPDATE ON sysadm.ps_ord_test TO alison WITH GRANT OPTION;

    After that you will be able to grant those rights on that table to any other user, while your sysadm will keep enjoing his peace and tranquility
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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


Click Here to Expand Forum to Full Width