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: 68042
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: DBUSER rights and role
Next Topic: Virtual Private Database update policy on complex views
Goto Forum:

Current Time: Wed Dec 01 07:03:22 CST 2021