ORA-01952:未授予“ROJIB”系统权限

Question

为什么我获得ORA-01952：系统特权未授予“ROJIB”？

创建角色：

SQL> create role security;

Role created.

然后为角色“安全性”创建授权：

SQL> grant create table,create view to security;

Grant succeeded.

授予用户:

SQL> grant security to rojib;

Grant succeeded.

撤销后，我收到错误：

SQL> revoke create table from rojib;
revoke create table from rojib
*
ERROR at line 1:
ORA-01952: system privileges not granted to 'ROJIB'

Answer 1

为什么我获得ORA-01952：系统特权未授予“ROJIB”？

这是因为您向角色< code>SECURITY授予了权限，所以您需要从角色< code>SECURITY而不是用户那里撤销权限。

比如说，

创建用户:

SQL> CREATE USER TEST IDENTIFIED BY TEST;

User created.

创建角色：

SQL> CREATE ROLE SECURITY;

Role created.

授予角色权限：

SQL> GRANT CREATE TABLE,CREATE VIEW TO SECURITY;

Grant succeeded.

向用户授予角色:

SQL> GRANT SECURITY TO TEST;

Grant succeeded.

从ROLE撤销特权：

SQL> REVOKE CREATE TABLE FROM SECURITY;

Revoke succeeded.

撤销用户的角色:

SQL> REVOKE SECURITY FROM TEST;

Revoke succeeded.