oracle权限RL_DB_ADMIN,Oracle中用户的创建和权限设置

#SQLPLUS /NOLOG

SQL> CONN / AS SYSDBA;

SQL> CREATE USER XIMING IDENTIFIED BY "XIMING123" ACCOUNT UNLOCK DEFAULT TABLESPACE TS_XIMING_DATA TEMPORARY TABLESPACE TS_XIMING_TMP; --USERNAME/PASSWORD都是用户自定义，创建用户时，需要指定数据表空间和，临时表空间

SQL> GRANT UNLIMITED TABLESPACE,SELECT ANY TABLE,SELECT ANY DICTIONARY TO XIMING;

SQL> GRANT CREATE SESSION,CONNECT TO XIMING;

SQL> GRANT CREATE ANY TABLE ,DROP ANY TABLE, CREATE ANY INDEX ,DROP ANY INDEX,ALTER ANY TABLE,COMMENT ANY TABLE,UPDATE ANY TABLE,INSERT ANY TABLE,DELETE ANY TABLE TO XIMING;

SQL> GRANT CREATE ANY VIEW ,DROP ANY VIEW TO XIMING;

SQL> GRANT CREATE ANY PROCEDURE,ALTER ANY PROCEDURE TO XIMING;

SQL> CONN XIMING/XIMING123

SQL> SELECT * FROM USER_SYS_PRIVS;--查看当前用户所有权限

一、创建

SYS;--系统管理员，拥有最高权限

SYSTEM;--本地管理员，次高权限

SCOTT;--普通用户，密码默认为TIGER,默认未解锁

ORACLE有三个默认的用户名和密码

1.用户名:SYS密码:CHANGE_ON_INSTALL

2.用户名:SYSTEM密码:MANAGER

3.用户名:SCOTT密码:TIGER