Insufficient privilege error when creating view

Question

I am trying to create a view that is referencing to dba_objects table. I can select the dba_objects just fine but when I try to create a view I am getting an insuf priv error.

select * from session_privs //this returns create view privilege

create view v_test_view 
as 
select * from dba_objects
where owner = 'HR'

ORA-01031: insufficient privileges

grant privilege by `grant select on dba_objects to ` from sys or system users. — Barbaros Özhan, Feb 14 '20 at 06:08
See [this](https://stackoverflow.com/questions/20595701/grant-create-view-on-oracle-11g) SO post if it helps. Cheers — Ennio71, Feb 17 '20 at 13:45

score 0 · Answer 1 · answered Feb 14 '20 at 06:07

0

You aren't allowed to select from DBA_OBJECTS. A privileged user (such as SYS) has to grant you select privilege on it.

Alternatively, if it is enough for what you're doing, select from ALL_OBJECTS which contains all objects you have access to.

answered Feb 14 '20 at 06:07

Littlefoot

131,892
15
35
57

I can select dba_objects with no issues at all. – user2058738 Feb 14 '20 at 06:11
1

Try to grant `SELECT ANY DICTIONARY` to user which is creating the view. – Littlefoot Feb 14 '20 at 06:16

Insufficient privilege error when creating view

1 Answers1