insufficient privileges error help

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: