#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