首页 > 代码库 > Oracle12C用户创建、授权、登录
Oracle12C用户创建、授权、登录
col pdb_name for a30
Oracle12C用户创建、授权、登录
1.以系统用户登录
命令
sqlplus sys/dwh as sysdba;
2. 确认选择CDB
select name,cdb from v$database;
col pdb_name for a30
select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
CON_ID DBID NAME OPEN_MODE ---------- ---------- ------------------------------ ---------- 2 964253477 PDB$SEED READ ONLY 3 3329151580 ORCLPDB MOUNTED
3.创建使用者为test
SQL> create user c##test identified by test; SQL> alter session set container=PDBORCL; 会话已更改。 SQL> show con_name; 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>
5.修改plsql登录配置
D:\java\Orcal_database\Orcal\virtual\product\12.2.0\dbhome_1\network\admin\tnsnames.ora文件中添加
ORCLPDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = http://www.mamicode.com/(SERVER = DEDICATED)>
6.plsq登录
Oracle12C用户创建、授权、登录
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。