/* divided into four steps */
/* Step 1th: Create a temporary tablespace */
Create temporary tablespace kmyf_temp
Tempfile
' E:\app\pangxy\product\11.2.0\dbhome_1\kmyf_temp.dbf ' size 50m autoextend on
Next 50m maxsize 20480m extent management local;
/* Step 2nd: Create a data table space */
Create tablespace kmyf_data Logging
DataFile ' E:\app\pangxy\product\11.2.0\dbhome_1\kmyf_data.dbf ' size 50m autoextend on
Next 50m maxsize 20480m extent management local;
/* 3rd step: Create user and specify Tablespace */
Create user Jjyx identified by 33133313 default tablespace user_data temporary tablespace user_temp;
Create user Jjyx identified by 33133313 default tablespace kmyf_data temporary tablespace kmyf_temp;
/* Step 4th: Grant permissions to users */
Grant CONNECT,RESOURCE,DBA to Jjyx
Modify User Password
Alter user Jjyx identified by 33133313;
/* Delete User */
Drop User PDE cascade;
/* Delete Table space */delete tablespace
Oracle Database Add New user