| Retrieving Session Details [message #371163] |
Mon, 11 September 2000 14:18  |
Marcus Fernando
Messages: 34
Registered: September 2000
|
Member |
|
|
|
Whith a DBA user i can have informations about the session, like machine, name, osuser, etc, in the view v$session. Is there any way to have this data connected whith a commom user whithout give him the select_catalog_role ?
|
|
|
|
| Re: Retrieving Session Details [message #371186 is a reply to message #371163] |
Wed, 13 September 2000 09:15  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
You can connect as sys,
and grant select on v_$session to user1;
Now you can log on as user1 and do
select * from sys.v_$session;
The v_$session is the under lying view for
the synonym v$session.
Good luck
Bala
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
