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

Content with tags Security, Ownership chaining Rss

   Items 1 to 2 of 2   
 

Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server

I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?  Read more...
By Additional Articles 2010/12/02 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 2,220 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,701 reads
   Items 1 to 2 of 2   
 
Tags
schema (1)