anjan.ashok (10/9/2008)
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
You have confusion attack, try from begining create the user then add datawriter role then run this script:
use [Your_Database]
GO
GRANT INSERT TO [Your_User]
GO
use [Your_Database]
GO
GRANT SELECT TO [Your_User]
GO
use [Your_Database]
GO
GRANT UPDATE TO [Your_User]
GO
use [Your_Database]
GO
DENY DELETE TO [Your_User]
GO
use [Your_Database]
GO
GRANT ALTER TO [Your_User]
GO
use [Your_Database]
GO
GRANT CREATE TABLE TO [Your_User]
GO
use [Your_Database]
GO