Oracle数据库创建用户及设置表空间

--创建用户及设置表空间：

示例一：

-- Create the user

create user zjhis identified by zjhis

default tablespace USERS

temporary tablespace TEMP

profile DEFAULT

password expire;

-- Grant/Revoke role privileges

grant connect to zjhis;

grant dba to zjhis;

grant exp_full_database to zjhis;

grant imp_full_database to zjhis;

grant resource to zjhis;

-- Grant/Revoke system privileges

grant unlimited tablespace to zjhis;

示例二：

-- Create the user

create user EASYHRIP identified by easyhrip

default tablespace TS_EASYHRIP

temporary tablespace TEMP

profile DEFAULT;

-- Grant/Revoke object privileges

 

grant execute on sys.DBMS_PIPE to EASYHRIP;

-- Grant/Revoke role privileges

grant connect to EASYHRIP;

grant exp_full_database to EASYHRIP;

grant imp_full_database to EASYHRIP;

grant resource to EASYHRIP;

-- Grant/Revoke system privileges

grant debug connect session to EASYHRIP;

grant select any table to EASYHRIP;

grant unlimited tablespace to EASYHRIP;