-- Create the user
create user WGH_HX identified by goodluck
default tablespace LSYW_TBS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to WGH_HX;
grant dba to WGH_HX;
grant resource to WGH_HX;
-- Grant/Revoke system privileges
grant administer database trigger to WGH_HX;
grant create indextype to WGH_HX;
grant create library to WGH_HX;
grant create operator to WGH_HX;
grant create procedure to WGH_HX;
grant create public synonym to WGH_HX;
grant create sequence to WGH_HX;
grant create trigger to WGH_HX;
grant create type to WGH_HX;
grant drop public synonym to WGH_HX;
grant unlimited tablespace to WGH_HX;
create user WGH_HX identified by goodluck
default tablespace LSYW_TBS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to WGH_HX;
grant dba to WGH_HX;
grant resource to WGH_HX;
-- Grant/Revoke system privileges
grant administer database trigger to WGH_HX;
grant create indextype to WGH_HX;
grant create library to WGH_HX;
grant create operator to WGH_HX;
grant create procedure to WGH_HX;
grant create public synonym to WGH_HX;
grant create sequence to WGH_HX;
grant create trigger to WGH_HX;
grant create type to WGH_HX;
grant drop public synonym to WGH_HX;
grant unlimited tablespace to WGH_HX;