dbTalk Databases Forums  

Logging Who Logs In

comp.databases.sybase comp.databases.sybase


Discuss Logging Who Logs In in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
Carl Kayser
 
Posts: n/a

Default Re: Logging Who Logs In - 12-04-2008 , 06:27 AM







"Carl Kayser" <kayser_c (AT) bls (DOT) gov> wrote

Quote:
"Steven Backus" <backus (AT) episun7 (DOT) med.utah.edu> wrote in message
news:gh6all$pga (AT) episun7 (DOT) med.utah.edu...
How can I keep track of who logs into my ASE (15.0.2)?

Thanks,
Steve
--
Steven J. Backus Computer Specialist
University of Utah E-Mail: steven.backus (AT) utah (DOT) edu
Genetic Epidemiology Alternate: backus (AT) math (DOT) utah.edu
391 Chipeta Way -- Suite D Office: 801.587.9308
Salt Lake City, UT 84108-1266 http://www.math.utah.edu/~backus

A quick technique is to configure "log audit logon failure" and "log audit
logon success". The information will be in the (misnamed) error log. The
obvious differences with auditing is (1) the SAs normally see the error
log and the SSOs read the audit tables, and (2) auditing will also provide
logout information.

Should have been "... (2) auditing can also provide ..."

Matching audit login/logout pairings has to be done with a little bit of
care since abnormal terminations are not logged.




Reply With Quote
  #32  
Old   
Carl Kayser
 
Posts: n/a

Default Re: Logging Who Logs In - 12-04-2008 , 06:27 AM







"Carl Kayser" <kayser_c (AT) bls (DOT) gov> wrote

Quote:
"Steven Backus" <backus (AT) episun7 (DOT) med.utah.edu> wrote in message
news:gh6all$pga (AT) episun7 (DOT) med.utah.edu...
How can I keep track of who logs into my ASE (15.0.2)?

Thanks,
Steve
--
Steven J. Backus Computer Specialist
University of Utah E-Mail: steven.backus (AT) utah (DOT) edu
Genetic Epidemiology Alternate: backus (AT) math (DOT) utah.edu
391 Chipeta Way -- Suite D Office: 801.587.9308
Salt Lake City, UT 84108-1266 http://www.math.utah.edu/~backus

A quick technique is to configure "log audit logon failure" and "log audit
logon success". The information will be in the (misnamed) error log. The
obvious differences with auditing is (1) the SAs normally see the error
log and the SSOs read the audit tables, and (2) auditing will also provide
logout information.

Should have been "... (2) auditing can also provide ..."

Matching audit login/logout pairings has to be done with a little bit of
care since abnormal terminations are not logged.




Reply With Quote
  #33  
Old   
Carl Kayser
 
Posts: n/a

Default Re: Logging Who Logs In - 12-04-2008 , 06:27 AM




"Carl Kayser" <kayser_c (AT) bls (DOT) gov> wrote

Quote:
"Steven Backus" <backus (AT) episun7 (DOT) med.utah.edu> wrote in message
news:gh6all$pga (AT) episun7 (DOT) med.utah.edu...
How can I keep track of who logs into my ASE (15.0.2)?

Thanks,
Steve
--
Steven J. Backus Computer Specialist
University of Utah E-Mail: steven.backus (AT) utah (DOT) edu
Genetic Epidemiology Alternate: backus (AT) math (DOT) utah.edu
391 Chipeta Way -- Suite D Office: 801.587.9308
Salt Lake City, UT 84108-1266 http://www.math.utah.edu/~backus

A quick technique is to configure "log audit logon failure" and "log audit
logon success". The information will be in the (misnamed) error log. The
obvious differences with auditing is (1) the SAs normally see the error
log and the SSOs read the audit tables, and (2) auditing will also provide
logout information.

Should have been "... (2) auditing can also provide ..."

Matching audit login/logout pairings has to be done with a little bit of
care since abnormal terminations are not logged.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.