Home » RDBMS Server » Security » user_history$ view (Oracle, OEL5)
user_history$ view [message #593378] Fri, 16 August 2013 00:37 Go to next message
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: 65146
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.

Previous Topic: List of all bugs fixed in a CPU
Next Topic: VPD function for column masking with inner-select
Goto Forum:

Current Time: Mon Aug 21 03:36:44 CDT 2017

Total time taken to generate the page: 0.03509 seconds