Can any one please let me know why I can't view, even I have the Dba Priviliges, RECOVERY_CATALOG_OWNER Priviliges and Imp_Full_Database
and all of thses Roles have Create any View.
Here is the Query.
create or replace view tbv
as select TABLESPACE_NAME,
sum( BYTES) allocated_space
group by TABLESPACE_NAME;
Gives that Object Does not exits
But if I Issue this select statement, that works fine.
Thanks in Advance.
02-23-2001, 04:38 PM
You can't create "fixed" object with privileges granted by a role.
That's because roles can be enabled/disabled and if you could create a fixed object that feature would be meaninless.
So, if you want the view, connect as sys and grant yourself privileges on the v_$ views
I hope I'm clear
02-23-2001, 04:55 PM
What do you mean give the Priviliges on V$... Is there some specific View that I need to have privilege on to create any other view on those.
02-23-2001, 05:05 PM
I was confused because long time ago I was able to create a procedure select v$session only when I granted select on v_$session.
Anyway, enter as sys and grant to the user select on dba_data_files, I tested it and it worked.