本文介绍了一种在数据库中创建用户并为其分配默认表空间、临时表空间和配置文件的方法。此外，还详细说明了如何授予该用户连接、资源、创建视图、选择任何字典、无限表空间、创建作业及管理调度器等系统权限。
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;
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;
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
