Home » RDBMS Server » Security » privileage issue in V$session? (oracle 9i, windows xp)
privileage issue in V$session? [message #315106] Sat, 19 April 2008 02:27 Go to next message
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

Re: privileage issue in V$session? [message #315110 is a reply to message #315106] Sat, 19 April 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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

Re: privileage issue in V$session? [message #315113 is a reply to message #315106] Sat, 19 April 2008 03:05 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Mar 28 16:05:04 CDT 2024