I grant the create any view to the user name - the permissions granted to the user to create views, could you tell me how to withdraw the users create a view permissions (Oracle)

CodePudding user response:

Revoke the create any view from the user name

CodePudding user response:

 revoke sys_privi | role from the user | role | public 
Sys_privi: system permissions or role, 
Role: role 
User: user name 
Public: Oracle system for all users, 
Revoke the create any view from user name 

CodePudding user response:

It is ok to use revoke:
Revoke the create any view from user name;

CodePudding user response:

SQL> Connect the system/user login password;
SQL> Revoke any view from user name;