views:

44

answers:

0

Hi,

I need help to set GRANT CREATE, ALTER BUT DENY DROP DB Objects to db users using sql server 2008.

I've tried this but it returns error:

use DBName
GO
DENY DROP TO dbUser
Error: Incorrect syntax near 'DROP'.

Any help would be much appreciated. Many thanks..

rfs

related questions