给用户给予创建视图权限
给用户赋予创建视图权限
- 以dba用户登录
- sqlplus / as sysdba
- 赋予scott用户创建VIEW的权限
- grant create view to user1
- grant create view to user1
- 以user1用户登录oracle
- conn user1/user1
- 创建视图成功
- CREATE OR REPLACE VIEW viewTest AS
- SELECT * FROM emp where deptno = 18;