Oracle Common Operations

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