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.

Thanks,
Anjan

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

DENY ALTER ON SCHEMA::[dbo] to [someuser]