How To Deny Create Trigger

[kim1]

Hi,

The user account has db_ddladmin database role. I want to Deny the permission to Create Trigger to that account.

there is no such thing as

DENY CREATE TRIGGER TO....

Any idea?

Kim

 

[RickCole]

Have you tried DENY CREATE TABLE TO tablename.

I haven't tried it out but it might be what your looking for.


Rick.

 

[lode]

You can only use the Deny-statement with the following :

CREATE DATABASE
CREATE DEFAULT
CREATE PROCEDURE
CREATE RULE
CREATE TABLE
CREATE VIEW
BACKUP DATABASE
BACKUP LOG

Best regards.