How to quit PRIVILEGES???

[skanat]

With GRANT we add privileges to an object... but if now I don't want that privileges? If I want to QUIT them from the object??

Thanks people!
Bernat

 

[Marco Kalter]

You can use the REVOKE ... FROM command:

grant select on emp to scott

revoke select on emp from scott

------------------
Marco Kalter
Allround Automations

 

[skanat]

Thank you very much!!