Oracle如何实现用户维护

小编给大家分享一下Oracle如何实现用户维护，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

用户维护

（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;

以上是“Oracle如何实现用户维护”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！