新建用戶jack，授予connect、resource、unlimited tablespace權(quán)限，發(fā)現(xiàn)不能創(chuàng)建視圖

SQL> create or replaceview ts

2 as

3 select * from employees order by id;

create or replace view ts

*

ERROR at line 1:

ORA-01031: insufficient privileges

記得connect是包含create view權(quán)限的，于是查詢dba_sys_privs數(shù)據(jù)字典確認(rèn)connect的權(quán)限

SQL> r

1* select * fromdba_sys_privs where grantee='CONNECT'

GRANTEE PRIVILEGE ADMIN_

-------------------- -------------------- ------

CONNECT CREATESESSION NO

確認(rèn)到connect只有create session的權(quán)限后以sys登陸授予jack用戶create view權(quán)限

SQL> show user

USER is "SYS"

SQL> grant create view to jack;

Grant succeeded.

然后用jack用戶創(chuàng)建視圖

SQL> create or replace view ts

2 as

3 select id,salary from employees order by id;

View created.