в 13:46, 26 мая 2010

2010-05-26T13:46:16Z

Admin: 1 версия

2010-05-26T10:24:16Z

1 версия

Новая страница

== Creating a DDL Trigger that Audits Server-Level Events==



<source lang="sql">
4>
5> USE master
6> GO
Changed database context to "master".
1> -- Disallow new Logins on the SQL instance
2> CREATE TRIGGER trg_RestrictNewLogins
3> ON ALL SERVER
4> FOR CREATE_LOGIN
5> AS
6> PRINT "No login creations without DBA involvement."
7> ROLLBACK
8> GO
1>
2> CREATE LOGIN JoeS WITH PASSWORD = "Password"
3> GO
Msg 15118, Level 16, State 1, Server BCE67B1242DE45A\SQLEXPRESS, Line 2
Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
1>
2> drop trigger trg_RestrictNewLogins
3> GO
Msg 3701, Level 11, State 5, Server BCE67B1242DE45A\SQLEXPRESS, Line 2
Cannot drop the trigger "trg_RestrictNewLogins", because it does not exist or you do not have permission.</source>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL Server/T-SQL Tutorial/Trigger/Trigger on server - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия