Oracle Create tablespace, new user, and assign permissions example

Note the point:

1. If it is opened in a tool such as PL/SQL, directly modify the following code [ Italic bold Section ] to execute

2. Ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\", which is the path where you want to save the file

/ * divided into four steps * /

/* Step 1th: Create a temporary tablespace */

Create temporary tablespace user_temp

tempfile ' D:\oracle\oradata\Oracle9i\user_temp.dbf '

size 50m

Autoextend on

next 50m maxsize 20480m

extent management Local;

 

/ * Step 2nd: Create a data table space * /

Create tablespace user_data

Logging

datafile ' D:\oracle\oradata\Oracle9i\user_data.dbf '

size 50m

Autoextend on

next 50m maxsize 20480m

extent management Local;

 

/ * 3rd Step: Create user and specify Tablespace * /

Create user username identified by password

default tablespace user_data

temporary tablespace user_temp;

 

/ * Step 4th: Grant permissions to users * /

Grant CONNECT,RESOURCE,DBA to username;

Oracle Create tablespace, new user, and assign permissions example