insufficient privileges error help
- From: Eugene Pipko <epipko@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Nov 2010 11:23:18 -0800
Hi all,
I am running 11.2 d/b on Oracle Linux 5.
I wanted to grant users select on one column (name) in a sys table (v$database).
Couldn't find any solutions, but to create a view:
create or replace view db_name_v
as
(
Select name database_name,
decode(rtrim(name),'TAURUS', 'Prod') environment
from v$database
)
;
The user which creates a view has was granted DBA role and CREATE ANY VIEW
privs.
When I try to create a view I get:
SQL> create or replace view db_name_v
2 as
3 (
4 Select name database_name,
5 decode(rtrim(name),'TAURUS', 'Prod') environment
6 from v$database
7 )
8 ;
from v$database
*
ERROR at line 6:
ORA-01031: insufficient privileges
What else can I check?
Thanks,
Eugene
Other related posts:
