http://www.sqlservercentral.com/Content tagged Security, Schema posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)I have several objects, all in the same schema. Because of this, ownership chaining is working, as described in this previous tip. However, I don't want ownership chaining to be on, but I need the objects to remain in the same schema. How can I do this?

]]>http://www.sqlservercentral.com/redirect/articles/67825/Fri, 21 Aug 2009 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/67825/In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.

]]>http://www.sqlservercentral.com/redirect/articles/67739/Mon, 17 Aug 2009 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/67739/