Oracle gives user authorization _oracle user authorization _oracle user authorization
Grant (Authorization) command
The following is the USER01 authorization for the user created, as follows:
Grant Connect, resource to User01;
(2) REVOKE (REVOKE) permissions
The permissions that have been granted can be undone. For example, to undo the authorization in (1), the command is as follows:
Revoke connect, resource from User01;
A user with a DBA role can revoke other permissions from Connect, resource, and DBA for any other user or even another DBA. Of course, this is dangerous, so, unless really needed, DBA authority should not be arbitrarily granted to ordinary users who are not important. Revoking all of the permissions of a user does not mean that the user is removed from Oracle or that any tables created by the user are not destroyed, but simply prevents access to those tables. Other users who want to access these tables can access them as before.
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/