Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 124
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 Go to previous messageGo to next message
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: 124
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: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 03:27:18 CDT 2008

Total time taken to generate the page: 0.06258 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.