Oracle User Management

User management, mainly to explain the SQL classification of DCL. DCL Data Data control statements, mainly have grant (grant) and revoke (recycling) two commands.

--SYS LoginConn SYS/Orcl assysdba;--Create user dog, password Wangwang, at which time dog is not allowed to log in because there is no permissionCreate UserDog identified byWangwang;--Grant Create session permission, still unable to create table and sequenceGrant CreateSession toDog;--Grant connect (can log on to Oracle, cannot create entities, cannot create a database structure), and resource (can only create entities, cannot create database structure) permissionsGrantConnect,resource toDog

Permission Details

Log back in, you can create a table, and you will have user management issues

Alter UserDog identified byMiaomiao;--Change PasswordAlter UserDog password expire;--Make password InvalidAlter UserDog account lock;--Lock UserAlter UserDog account unlock;--Unlocking UsersGrant Select,Insert  onScott.emp toDog--GrantRevoke Insert  onScott.emp fromDog--Take backDrop UserDog Casecade;--delete users,Not a big point

Oracle User Management