Re: auditing users



If you have SP installed you can try DDL Trigger
Some examlpe.

create login AuditLogin with password = ?AuditLoginPswd?
go
/*Create a very simple login trigger */
create trigger AuditLogin_Demo
/* server means instance level*/
on all server
with execute as self
/* We specify the logon event at this stage
? If there are more than one connections,
? Issue a rollback*/
for logon
as begin
IF ORIGINAL_LOGIN()= ?AuditLogin? AND
(SELECT COUNT(*) FROM sys.dm_exec_sessions
WHERE is_user_process = 1 AND
original_login_name = ?AuditLogin?) > 1
ROLLBACK;
end
go

---Another way is tio create a Notification Event

CREATE EVENT NOTIFICATION Logging_Event_Notification
ON SERVER
FOR AUDIT_LOGIN, AUDIT_LOGOUT, AUDIT_LOGIN_FAILED
TO SERVICE 'LoggingService', 'current database'
GO

"Pure Heart" <PureHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E0D59B3-7341-4197-BECA-939E7206C3CC@xxxxxxxxxxxxxxxx
hi

ok thanx, i use sql 2005, express and standard edition
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


"Uri Dimant" wrote:

Pure
My intend was to get a version of SQL Server from you in order to help
with
problem





"Pure Heart" <PureHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9D52437A-C19C-487D-995B-7D1F37D0B2F6@xxxxxxxxxxxxxxxx
hi Uri

that link is about discovering the version not about logging auditing
for
user actions
also when i created the database a file named Developer1_log.ldf was
created
does this file have the logs and haw can i open it
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643


"Uri Dimant" wrote:

Pure
http://dimantdatabasesolutions.blogspot.com/2007/04/whats-version-of-sql-server.html



"Pure Heart" <PureHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C64FEF9-4671-47D8-B15F-24E90A2997D5@xxxxxxxxxxxxxxxx
hi

if i want to audit user actions on tables like data changed and
records
add
to specific tables haw can that be done ?
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643








.