Disabling execute privilege on login triggers

A database owner or administrator can disable execute privilege on the login trigger, or code the login trigger to permit access only at certain times. For example, you may want to prohibit regular users from using the server while the database owner or administrator is updating the table.

NoteIf the login trigger returns a negative number, the login fails.