If you are not creating this as user sys you have to grant select priveleges on v_$session directly to the user (not via a role)
Or if you intented to use this user as a general admin account you can grant select any dictionary (in 9i)
Regards
|
Results 1 to 4 of 4
Thread: select on v$sessionThreaded View
|
Click Here to Expand Forum to Full Width |