Home » RDBMS Server » Security » user_history$ view (Oracle 10.2.0.4.0, OEL5)
user_history$ view [message #593378] Fri, 16 August 2013 00:37 Go to next message
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 Go to previous message
Michel Cadot
Messages: 58934
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: DBUSER rights and role
Next Topic: Virtual Private Database update policy on complex views
Goto Forum:
  


Current Time: Fri Aug 29 03:28:18 CDT 2014

Total time taken to generate the page: 0.19049 seconds