Issue with Revoke statement
Posted by: Nancy Kenney
Date: March 07, 2016 08:43AM

I need to revoke all privs except SELECT on a Database table.

REVOKE INSERT, UPDATE, DELETE ON 'trackingdb(PDCert).PACTICAL_APP_DOCUMENT_CONFIRM' FROM 'PDCert'@'%'

I keep getting back the infamous 1064 error. Any ideas why I have done wrong?

Options: ReplyQuote


Subject
Written By
Posted
Issue with Revoke statement
March 07, 2016 08:43AM


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.