drop user xd(用户名) CASCADE;
-- Create the user
create user xd
identified by xd
default tablespace SYSTEM
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to xd with admin option;
grant resource to xd with admin option;
grant dba to xd with admin option;
-- Create the user
create user xd
identified by xd
default tablespace SYSTEM
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to xd with admin option;
grant resource to xd with admin option;
grant dba to xd with admin option;