创建用户命令

2017-09-13 20:37:34来源:CSDN作者:wrh_csdn人点击

分享
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;

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台