Oracle user management instance, oracle user management
User Roles in oracle are divided into predefined roles and custom roles.
A role is a combination of common permissions to form a role.
Authorization/Role Assignment Command
Grant permission/role to user
Command for revoking permissions:
Revoke
Comprehensive case:
Create a user wangwu and assign two roles to the user so that the user can log on and create a table, perform the CRUD operation, reclaim the corresponding roles, and delete the user.
1. Create a user:
2. Grant two common roles:
3. wangwu Logon:
4. change the password of wangwu:
5. wangwu creates a table and inserts data into the table:
6. revoke a role. To revoke a role, you must first switch the user to system:
7. Authorize and revoke permissions:
8. delete a user:
When deleting a user, if the user has already created a data object, you need to add the option cascade to delete all the data objects created by the user.
If you do not want to delete the data objects created by the user, you can freeze the user account.