创建用户
-- Create the user create user MEP identified by whq1987 default tablespace MEP temporary tablespace MEP_TEMP profile DEFAULT; -- Grant/Revoke role privileges grant connect to MEP; grant datapump_exp_full_database to MEP; grant datapump_imp_full_database to MEP; grant dba to MEP; grant exp_full_database to MEP; grant imp_full_database to MEP; grant resource to MEP; -- Grant/Revoke system privileges grant alter_user to MEP; grant comment any table to MEP; grant create any view to MEP; grant create session to MEP; grant create user to MEP; grant delete any table to MEP; grant drop user to MEP; grant export full database to MEP; grant unlimited tablespace to MEP;