Home Forums SQL Server 2005 SQL Server 2005 Security Deny delete and drop permission to the sql user RE: Deny delete and drop permission to the sql user
anjan.ashok
SSCrazy
Points: 2783
More actions
October 9, 2008 at 10:55 am
#883035
Hi dugi,
If i grant create table and alter permission, then the user can drop the table i have crosschecked, but if deny createtable and alter table then the user can't drop table.
So how fix this.:hehe:
Thanks,
Anjan