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

Thread: error on revoke command

  1. 03-13-2003, 06:43 AM #1
    raf
    raf is offline Member
    Join Date
    Jul 2002
    Posts
    228

    error on revoke command

    Hi,
    I want revoke delete on table A to user TOM.

    I WROTE THIS:

    CONNECT SYSTEM/MANAGER@DBNAME

    REVOKE DELETE on TOM.A FROM TOM;

    but I get this error:

    ORA-01927: cannot REVOKE privileges you did not grant

    What I wrong???

    Thanks
    Reply With Quote Reply With Quote
  2. 03-13-2003, 06:53 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You cannot revoke privileges on an object from the owner of the object.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 03-13-2003, 07:00 AM #3
    raf
    raf is offline Member
    Join Date
    Jul 2002
    Posts
    228
    ok.....but I don't want that user tom delete the table A.

    How can I do??

    Raf
    Reply With Quote Reply With Quote
  4. 03-13-2003, 07:06 AM #4
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I think you can do it with a trigger on the table.

    Another would be to create a user who as specific access to TOM's tables and use that user in the application.

    Regards
    Last edited by jovery; 03-13-2003 at 07:12 AM.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  5. 03-13-2003, 07:11 AM #5
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hard way, move it to different tablespace and make that tablespace read-only
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  6. 03-13-2003, 07:14 AM #6
    raf
    raf is offline Member
    Join Date
    Jul 2002
    Posts
    228
    but if I create a new tablespace read only Tom can insert a new record???
    Reply With Quote Reply With Quote
  7. 03-13-2003, 07:20 AM #7
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Raf

    No DML is permitted on read only tablespace..

    regards
    Hrishy
    Reply With Quote Reply With Quote
  8. 03-13-2003, 07:20 AM #8
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    No.
    Bad idea. Go with jim's suggestion
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width