Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Common StatementsRSS Feeds

REVOKE

Posted By: Birk Fischer     Category: Oracle     Views: 3073

REVOKE with example in oracle.

REVOKE

REVOKE role FROM user;

or

REVOKE {object_priv | ALL [PRIVILEGES]}
[, {object_priv | ALL [PRIVILEGES]} ] ...
ON [schema.]object
FROM {user | role | PUBLIC} [, {user | role | PUBLIC}] ...

REVOKE command removes a database privilege from a user, whether it be a system privilege or a role. 

  
Share: 

 
 
 

Didn't find what you were looking for? Find more on REVOKE Or get search suggestion and latest updates.

Birk Fischer
Birk Fischer author of REVOKE is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!