Oracle12C用户创建、授权、登录
1.以系统用户登录
C:UsersLEI>sqlplus sys/dwh as sysdba;
SQL*Plus: Release 12.1.0.2.0 Production on 星期四 12月 31 10:11:29 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
连接到:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
2. 确认选择CDB
> ,
--------- ---
>
> ,,,,
---------- ------------------------------ ---------- --------- ------------
> ,,,
---------- ---------- ------------------------------ ----------
3.创建使用者为test
SQL> create user c##test identified by test;
SQL> alter session set container=PDBORCL;
会话已更改。
SQL> show con_name;
PDBORCL
4.创建真正的用户
SQL> startup;
插接式数据库已打开。
SQL> create user test identified by test default tablespace users temporary tablespace temp;
用户已创建。
SQL> grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to test ;
授权成功。
SQL>