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

Thread: error on revoke command

  1. #1
    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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Don't post the same question in multiple forums!

    Answered in Database Administration.
    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!

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