LOGIN: Conn username/password
Create user user name identified by password
Change Password Password user name
Delete User drop username user
If the user you want to delete has already created the table, then delete the parameter cascade
Grant permission to User name
Permissions: System permissions (user-related permissions to the database), object permissions (user access to other users ' data objects, permission to operate)
Role: A collection that contains several permissions (custom roles (user defined), predefined roles (System has))
Grant permission on Operation Target to User (authorization)
Revoke permissions on operation target from user (Reclaim permissions)
Grant object permissions on operation target to user with option (authority to grant continued authorization)
Grant system permissions on operation target to user with admin option (authority to grant continued authorization)
Lock User:
Sql> Create Frofile file name//Create profile (define rule)
Limite failed_login_attempts no1//attempt error times No1
Password_loke_time no2//lock Time NO2 days
sql> alter user username Frofile file name//rule of the file point to User
Unlock:
Sql>alter User Username Profile account Unloke
Terminate password (change password instance periodically):
Sql> Create Frofile file name//Create profile (define rule)
Limite password_life_time no1//Set password valid time No1 days
Password_grace_time no2//delay Time NO2 days
sql> Alter user Username profile file name//file rules point to User
Password history:
Sql> Create Frofile file name//Create profile (define rule)
Limite password_life_time no1//Set password valid time No1 days
Password_grace_time no2//delay Time NO2 days
Password_reuse_time no3//specified password NO3 days later available again
sql> Alter user Username profile file name//file rules point to User
To delete a file:
Drop profile filename "cascade"
Oracle Account Management