privileage issue in V$session? [message #315106] |
Sat, 19 April 2008 02:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mm_kanish05
Messages: 493 Registered: January 2007 Location: Chennai
|
Senior Member |
![mm_kanish05%40yahoo.co.in](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi
Can I capture the v$session "username".
When i login as "normal user" i cant see the table
even when i try to give privilege to the "normal user"
im getting error
ora - 02030: Can only select from fixed tables/views
pls guide me.
Thanks in advance
wbr
kanish
|
|
|
Re: privileage issue in V$session? [message #315110 is a reply to message #315106] |
Sat, 19 April 2008 02:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68659 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Yes, only SYS can give select privilege and on the underlying view v_$session.
But the most important question is "why do you want to give access to v$session? What do you want to achieve?" Giving privileges on v$session is probably not the best way.
Regards
Michel
[Updated on: Sat, 19 April 2008 02:39] Report message to a moderator
|
|
|
|
|