- 以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;
给用户赋予创建视图权限
最新推荐文章于 2023-12-28 10:38:26 发布