|
Home > Archive > MS SQL Server > February 2006 > SQL Server 2005 DDL Triggers on Database - Permissions?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2005 DDL Triggers on Database - Permissions?
|
|
| SteveM 2006-02-15, 11:23 am |
| As an SA, I can create DDL triggers on some of our more important
databases. However, how do I prevent the dbo's in the database from
deleting or disabling these triggers?
| |
| Sune Due Moeller 2006-02-16, 7:23 am |
| HI Steve,
You can't do that without removing them from the dbo database role.
How about adding them to the ddladmin and datareader and datawriter roles
instead, and DENY the ALTER ANY DLL TRIGGER securable?
"SteveM" wrote:
> As an SA, I can create DDL triggers on some of our more important
> databases. However, how do I prevent the dbo's in the database from
> deleting or disabling these triggers?
>
>
|
|
|
|
|