sql server permissions help.. denying drop object?
I need to deny drop table access on all logins except sa but I can't seem
to do this without also denying create/modify object access.
I took a different approach and created a new login group called SQLAdmin,
and granted it read, write on all objects. I then granted it create table,
create view, create procedure access. This seems to be fine and restricks
SQLAdmin from dropping objects, but I cant go into design mode to change
Does anyone know any other way?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL