1. Create a new user (normal)
Create user username identified by password
example, create a user named Xiaoming, with a password of XM
2. Change the password to a normal user as an administrator (when the average user forgets his or her password)
Alter user username identified by new password
3. Create a new user (advanced)
The first line here doesn't have to be explained, the second line represents the default tablespace used by the user-created table, the third row represents the temporary tablespace used by the user-created table, and the fourth row indicates that the user-created Data object (table, view, and so on) has a maximum size of 3M, after which the system prompts the user for insufficient space.
4. Assigning permissions to new users
The newly created user does not have any permissions, so the newly created user cannot log on.
Assign logon rights to new users:
But at this time the xiaoming only can log in, other permissions are still not available.
System permissions:
Create Session Login Permissions
CREATE TABLE permissions for creating tables
Create INDEX permissions for creating indexes
Create View permissions for creating views
Create sequence creating sequence permissions
Create Trriger Creating Trigger permissions
....
Object permissions:
Update
Insert
Delete
Select
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Getting Started with Oracle User management