oracle11g数据库需求：ora_select_user 这个能分配只创建视图的权限吗
涉及到oracle的代码命令
GRANT CREATE VIEW TO ora_select_user;-- 禁止 DDL 操作（如创建表、修改视图）
REVOKE CREATE TABLE FROM ora_select_user;
REVOKE CREATE SEQUENCE FROM ora_select_user;
REVOKE CREATE PROCEDURE FROM ora_select_user;
REVOKE CREATE TRIGGER FROM ora_select_user;
REVOKE CREATE CLUSTER FROM ora_select_user;
REVOKE CREATE INDEX FROM ora_select_user;
REVOKE ALTER ANY TABLE FROM ora_select_user;-- 禁止 DML 操作（如 INSERT/UPDATE/DELETE）
REVOKE INSERT, UPDATE, DELETE ON schema_name.sales, schema_name.customers FROM ora_select_user;
具体执行的过程记录：
[oracle@ai-tst-db01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 10 10:26:54 2025
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> GRANT CREATE VIEW TO ora_select_use;
Grant succeeded.
SQL> REVOKE CREATE TABLE FROM ora_select_user;
Revoke succeeded.
下面这种的报错信息的意思是：该用户从来没有被授予这个权限。
SQL> REVOKE CREATE TABLE FROM ora_select_user;
REVOKE CREATE TABLE FROM ora_select_user
*
ERROR at line 1:
ORA-01952: system privileges not granted to 'ora_select_user'图1
图2
结束。