OraFAQ Forum: Security » privileage issue in V$session?

Home » RDBMS Server » Security » privileage issue in V$session? (oracle 9i, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

privileage issue in V$session? [message #315106]

Sat, 19 April 2008 02:27

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

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

Report message to a moderator

Re: privileage issue in V$session? [message #315110 is a reply to message #315106]

Sat, 19 April 2008 02:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Re: privileage issue in V$session? [message #315113 is a reply to message #315106]

Sat, 19 April 2008 03:05

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

just want to record who is the user

like to identify who is create the document (who owner for that document) by login

[Updated on: Sat, 19 April 2008 03:07]

Report message to a moderator

Re: privileage issue in V$session? [message #315117 is a reply to message #315113]

Sat, 19 April 2008 03:10

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The current user is given by the function... tada... USER. To verify it, just try:

select user from dual;

Regards
Michel

[Edit: add link to function]

[Updated on: Sat, 19 April 2008 03:12]

Report message to a moderator

Previous Topic:	Cannot login as sysdba
Next Topic:	User Privilege

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 03:31:19 CST 2024