Log in Linux,sqlplus/as sysdba to log on as an administrator, normal users do not have permission to create and delete users
To create a user:
1, CREATE database table space, if the user belongs to the table space, then limit the amount of space users use
Create tablespace tablespace name datafile ' xx.dbf ' size 3000m; ------------3000m means 3000M
2, create the user, if you do not specify a tablespace, the system allocates the default tablespace, the DBA can modify the default table space
Create user username identified by password default tablespace user which tablespace to use;
3, modify the user rights, the new user does not have permissions, ordinary users under the empowerment statement is sufficient
Grant DBA, connect to user name;
To delete a user:
DROP tablespace tablespace name [including CONTENTS [and Datafiles] [CASCADE CONSTRAINTS]
Including CONTENTS: Delete all contents in table space
and datafiles: Deleting a DBF data file
CASCADE CONSTRAINTS: If a table outside the table space that you want to delete references a table in that table space , the primary key and unique key, this referential integrity constraint is removed
Oracle Common Operations