用户维护
（1）创建用户
CREATE USER suntx IDENTIFIED BY "suntx"
DEFAULT TABLESPACE "SUNTX"
TEMPORARY TABLESPACE "SUNTX_TEMP"
PROFILE DEFAULT
QUOTA UNLIMITED ON "SUNTX";
（2）给用户赋权
2. 运行以下命令，对用户赋权；
grant execute on dbms_lock to suntx;
grant create any directory to suntx;
GRANT CONNECT TO suntx;
GRANT RESOURCE TO suntx;
create directory DUMP_DIR as '/app/sunline/db';
create directory BACKUP_DUMP_DIR as '/app1/backup/week/exp'
grant read,write on directory DUMP_DIR to suntx;
grant create synonym to suntx;
grant execute on dbms_lock to sunstg;
grant connect to SUNSTG;
grant resource to SUNSTG;
-- Grant/Revoke system privileges
grant create database link to SUNSTG;
grant create procedure to SUNSTG;
grant create sequence to SUNSTG;
grant create table to SUNSTG;
grant create trigger to SUNSTG;
grant create view to SUNSTG;
grant debug any procedure to SUNSTG;
grant debug connect session to SUNSTG;
grant create synonym to suntx;
grant unlimited tablespace to SUNSTG;
（1）创建用户
CREATE USER suntx IDENTIFIED BY "suntx"
DEFAULT TABLESPACE "SUNTX"
TEMPORARY TABLESPACE "SUNTX_TEMP"
PROFILE DEFAULT
QUOTA UNLIMITED ON "SUNTX";
（2）给用户赋权
2. 运行以下命令，对用户赋权；
grant execute on dbms_lock to suntx;
grant create any directory to suntx;
GRANT CONNECT TO suntx;
GRANT RESOURCE TO suntx;
create directory DUMP_DIR as '/app/sunline/db';
create directory BACKUP_DUMP_DIR as '/app1/backup/week/exp'
grant read,write on directory DUMP_DIR to suntx;
grant create synonym to suntx;
grant execute on dbms_lock to sunstg;
grant connect to SUNSTG;
grant resource to SUNSTG;
-- Grant/Revoke system privileges
grant create database link to SUNSTG;
grant create procedure to SUNSTG;
grant create sequence to SUNSTG;
grant create table to SUNSTG;
grant create trigger to SUNSTG;
grant create view to SUNSTG;
grant debug any procedure to SUNSTG;
grant debug connect session to SUNSTG;
grant create synonym to suntx;
grant unlimited tablespace to SUNSTG;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28291944/viewspace-2143718/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle表空间维护
下一篇：
Oracle创建db_link
请登录后发表评论
登录
全部评论
