When we allow a user to make some desired or allowed operation for a time specified.he can do any operation and whenever the owner want to cancel the permitted privileges,the owner can release that privileges again.
The statements which is used to allow the privileges to a user.the vice versa statement is being used to revoke or release the permission on the object from the database user.
The statement used to revoke the privileges would be as follows:
Code:
REVOKE SELECT,UPDATE ON MY_TABLE FROM MARTIN;
Bookmarks