创建用户命令

create user test_sdkop_dev identified by 123456
  default tablespace omms_data
  temporary tablespace tempnew
  profile default;
-- grant/revoke role privileges 
grant connect to test_sdkop_dev;
grant resource to test_sdkop_dev;
-- grant/revoke system privileges 
grant create view to test_sdkop_dev;
grant select any dictionary to test_sdkop_dev;
grant unlimited tablespace to test_sdkop_dev;
grant create job to test_sdkop_dev;
grant manage scheduler to test_sdkop_dev;