Issue with Revoke Statement
Posted by: Nancy Kenney
Date: July 14, 2016 12:12PM

Hello,

I am trying to revoke all privs except for SELECT from a table. Here is my statement:
REVOKE INSERT, UPDATE, DELETE ON 'orgtrack(PDIICert)'.PRACTICAL_APP_DOCUMENT_CONFIRM FROM 'PDIICert'@'%'

I keep getting a 1604 but honestly I have played around this for hours and cen not see the issue. Anyone have any ideas, I would greatly appreciate it.

Options: ReplyQuote


Subject
Written By
Posted
Issue with Revoke Statement
July 14, 2016 12:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.