Let assume you are using Windows Authentication with SQL Server 2005, you've added a new server account for domain group and would like to give it a default schema. The properties window is the same for users and groups but the default schema field is...

Last month I’m working with a client to create something like non-standard security model. He asked for the following features: - server–level management only for sa (server admin). - database–level management for dbo (one or more dbo per database...

Few days ago I worked for one client. He uses the following business model: - dbo usually responsible for high level database design and maintenance; - all database users organized in additional security groups for security purposes; - dedicated...