Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database users

Status
Not open for further replies.
teser

teser

Technical User
Mar 6, 2001
194
0
0
US
Is it possible to write a PL/SQL script to let you know when users log into an 8.0.4 Oracle database?
 
Sort by date Sort by votes
I think you should rather use the auditing facility of Oracle. I haven't tested it but I think the syntax that would help you would be:
audit session by username;
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
312
carp
carp
Aung Thurein Tun
  • Locked
  • Question
opera_mail.AuthenticateCredential error ORA-20001 in Oracle Database
Replies
0
Views
81
Aung Thurein Tun
Aung Thurein Tun
BJoy
  • Locked
  • Question
Bulk insert from C# into Oracle Database
Replies
4
Views
127
karluk
karluk
billo102
  • Locked
  • Question
stats collection on DG affects standby database
Replies
0
Views
73
billo102
billo102
tekpr00
  • Locked
  • Question
Database Capacity Trend
Replies
0
Views
32
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top