Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Security, Schema Rss

   Items 1 to 4 of 4   
 

Default schema

By Anoo S Pillai 2014/03/31 | Category: schema
Rating: (not yet rated) |  Discuss |   Briefcase | 1,798 reads

Schema & Renaming Fun

By Andy Warren 2014/03/12 | Category: schema
Rating: (not yet rated) |  Discuss |   Briefcase | 1,736 reads

Breaking ownership chaining within a schema in SQL Server

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?  Read more...
By Additional Articles 2009/08/21 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,688 reads

Granting limited permissions to create views in another schema in SQL Server - Part 2

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.  Read more...
By Additional Articles 2009/08/17 | Source: MSSQLTips.com | Category: schema
Rating: (not yet rated)  Rate this |   Briefcase | 2,744 reads
   Items 1 to 4 of 4   
 
Tags
ddl triggers (1)    
ownership chaining (1)    
rename (1)