469,090 Members | 1,183 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Cannot read from sys.v_$session

I have done the following as dbo:

grant select on sys.v_$session to dbo;
create or replace view z as select * from sys.v_$session ;

But the second command gives me:
ERROR at line 1:
ORA-00942: table or view does not exist

I can select directly from sys.v_$session by
select * from sys.v_$session;

What do I have to do/grant permission wise to be able to create a view
or PL/SQL function which accesses sys.v_$session?

Regards
Chris (ch********@msn.com)
Jul 19 '05 #1
1 6494
ch********@msn.com (Chris Jack) wrote in message news:<64**************************@posting.google. com>...
I have done the following as dbo:

grant select on sys.v_$session to dbo;
create or replace view z as select * from sys.v_$session ;

But the second command gives me:
ERROR at line 1:
ORA-00942: table or view does not exist

I can select directly from sys.v_$session by
select * from sys.v_$session;

What do I have to do/grant permission wise to be able to create a view
or PL/SQL function which accesses sys.v_$session?

Regards
Chris (ch********@msn.com)


Because as the procedure or view owner you can grant access to your
object to others, but because you reference objects owned by third
parties you must have a direct grant on the foreign object and have
the avility to grant access to others (with grant option). See the
DBA Administration manual and SQL manual sections on managing object
privileges.

HTH -- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by mrbog | last post: by
1 post views Thread by Raed Sawalha | last post: by
5 posts views Thread by Oleg Ogurok | last post: by
5 posts views Thread by ┼×enol Akbulak | last post: by
17 posts views Thread by Jan Kucera | last post: by
5 posts views Thread by rug | last post: by
1 post views Thread by Chris Jack | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.