oracle普通用户,如何在oracle 12c中创建普通用户
发布日期:2021-10-27 15:17:53 浏览次数:27 分类:技术文章

本文共 2998 字,大约阅读时间需要 9 分钟。

-------如何在oracle 12c中创建普通用户-------

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 21:43:50 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

--通过con_name能看到当前登录的环境是CDB根库,CDB包含一个名为PDBORCL的可插拔库。

SQL> show con_name pdbs;

CON_NAME

------------------------------

CDB$ROOT

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDBORCL MOUNTED

--创建公用用户admin,需要使用C##或者c##作为该用户名的开头。

SQL> create user C##admin identified by Lxf$txx282534;

User created.

--如果使用普通方法创建会报错

SQL> create user admin identified by Lxf$txx282534;

create user admin identified by Lxf$txx282534

*

ERROR at line 1:

ORA-65096: invalid common user or role name

--创建公用角色, 同公用用户一样也需要使用C##或者c##作为角色名的开头。

SQL> create role C##admin01 container=all;

Role created.

--将dba角色授予公用角色, 适用范围为所有PDB

SQL> grant dba to c##admin01 container=all;

Grant succeeded.

--将公用角色授予公用用户, 使用范围为所有PDB

SQL> grant C##admin01 to C##admin container=all;

Grant succeeded.

--下面使用公用用户分别登录CDB、PDB看看是否通用。

[[email protected] admin]$ sqlplus [email protected]

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 22:33:29 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Sun Nov 29 2015 22:31:12 +08:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show con_name;

CON_NAME

------------------------------

PDBORCL

[[email protected] admin]$ sqlplus C##admin/‘Lxf$txx282534‘

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 22:33:53 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Sun Nov 29 2015 22:33:29 +08:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show con_name;

CON_NAME

------------------------------

CDB$ROOT

在PDB中创建用户和创建普通用户就没有什么区别了

SQL> create user test identified by test;

User created.

SQL> grant create session to test;

Grant succeeded.

[[email protected] admin]$ sqlplus [email protected]

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 29 22:17:16 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show user

USER is "TEST"

SQL> show con_name

CON_NAME

------------------------------

PDBORCL

SQL> exit

--将PDB打开

SQL> alter pluggable database pdborcl open;

Pluggable database altered.

--切换到PDB容器

SQL> alter session set container=pdborcl;

Session altered.

原文:http://www.cnblogs.com/Anonymous-1/p/5005867.html

转载地址:https://blog.csdn.net/weixin_35172279/article/details/116316970 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!

上一篇:oracle 返回unicode,OracleClient中加入Unicode=true
下一篇:php写入bitlock分区,Windows7如何用BitLockter给单个磁盘加密

发表评论

最新留言

初次前来,多多关照!
[***.217.46.12]2024年03月20日 04时27分43秒