首页 > 编程知识 正文

oracle查不到job,oracle添加用户

时间:2023-05-03 10:37:06 阅读:60246 作者:1673

每个数据文件20G,共计200G

createtablespacestgdatafile‘h :/ora _ TBS/stg 01.DBF‘size 20 gextentmanagementlocalsegmentspacemanagementagementautauto;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 02.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 03.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 04.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 05.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 06.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 07.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 08.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 09.DBF‘size 20g;

altertablespacestgadddatafile‘h :/ora _ TBS/stg 10.DBF‘size 20g;

createuserstgidentifiedbystgdefaulttablespacestgtemporarytablespacetemp;

授权连接,资源到stg;

grant dba to stg;

-表空间的用户验证

alteruserstgquotaunlimitedonstg;

授权创建any table to stg;

授权更新any table to stg;

grant select any table to stg;

授权插入any table to stg;

grant drop any table to stg;

授权删除any table to stg;

grant create any index to stg;

Grop any index to stg;

grant comment any table to stg;

grant execute any procedure to stg;

- createorreplacedirectoryoraxrpdslas‘/home/Oracle/oraxrpdsl‘;

- -授权写入,readondirectoryoraxrpdsltojmbsuser;

grantselectondba _ jobs _ runningtostg;

grant select on dba_jobs to stg;

grant select on v_$session to stg;

grant select on v_$process to stg;

grant execute on dbms_lock to stg;

grant execute on dbms_job to stg;

授权Alter session to stg;

授权Alter系统至stg;

grantselectondba _ data _ filestostg;

gantselectondba _ free _ spacet ostg;

授权创建any view to stg;

grant drop any view to stg;

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。