Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle REVOKE Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: REVOKE

Definition:
In Oracle PL/SQL, the term REVOKE refers to removing or "un-granting" a privilege.

For example, if you revoke the UPDATE privilege from a user, that user will no longer be able to update tables or other objects in their schema.

If the UPDATE privilege is revoked from a role, user's who have been granted that role will no longer be able to update tables or other objects in their schema (assuming they don't have the UPDATE privilege enabled through any other grant or role).

Example Syntax:

This example demonstrates revoking the UPDATE privilege from the user "bob" on the sales table:

REVOKE UPDATE ON sales FROM bob;


If public (all users) had been granted privileges on sales and you wanted to completely revoke those privileges, you could execute the following REVOKE statement:

REVOKE ALL ON sales FROM public


For more syntax and code examples, please visit the Object Privileges page and the Oracle Roles page.




Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 209 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?