| user_history$ view [message #593378] |
Fri, 16 August 2013 00:37  |
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
|
Senior Member |
|
|
Hi Michel,I created a user and granted connect, resource to the user. but trying to select columns from the view USER_HISTORY$,it's showing no value, i tried to login the user several times, but it's displaying no value, any particular reason or any minor mistake?
|
|
|
|
| Re: user_history$ view [message #593383 is a reply to message #593378] |
Fri, 16 August 2013 01:18  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
This is the expected behaviour, you do not understand what it is for.
You have not to query this table, it is Oracle internal.
What do you want to do? Having history connections?
Activate audit (using audit_trail paramater) and activate audit on sessions (using AUDIT SESSION) then query DBA_AUDIT_SESSION.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
