12c Pluggable Database Container Database权限与角色管理

简介:
  pdb role privs    oracle@localhost:~$ oerr ora 65050 65050, 00000, "Common DDLs only allowed in CDB$ROOT" // *Cause: An attempt was made to issue a Common DDL in a pluggable database. // *Action: Switch to CDB$ROOT and issue the Common DDL there. // oracle@localhost:~$ oerr ora 65032 65032, 00000, "a Local Role may only be granted or revoked within the current Container" // *Cause: A user issued a GRANT or REVOKE statement specifying // CONTAINER=ALL and listing a Local Role among roles // to be granted or revoked, which is illegal. // *Action: If trying to revoke a Local Role, remove CONTAINER=ALL from // the statement. If trying to revoke Common Privileges and/or // Roles, remove Local Roles from the list of roles being granted // or revoked. //     LOCAL ROLE/PRIV 不能 grant to



http://blog.51cto.com/maclean/1278562

相关文章
|
6月前
|
Oracle 关系型数据库 数据库
实时计算 Flink版操作报错合集之错误信息"ORA-65040: operation not allowed from within a pluggable database"如何解决
在使用实时计算Flink版过程中,可能会遇到各种错误,了解这些错误的原因及解决方法对于高效排错至关重要。针对具体问题,查看Flink的日志是关键,它们通常会提供更详细的错误信息和堆栈跟踪,有助于定位问题。此外,Flink社区文档和官方论坛也是寻求帮助的好去处。以下是一些常见的操作报错及其可能的原因与解决策略。
333 2
|
SQL 关系型数据库 网络协议
|
6月前
|
SQL Oracle 关系型数据库
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
91 2
|
6月前
|
Oracle 关系型数据库
19c 开启Oracle Database Vault
19c 开启Oracle Database Vault
162 1