Tag Info

New answers tagged


Your options are: Use roles, and SET search_path on each role so it looks in the appropriate organization's schema. While in many ways the cleanest approach from a database perspective, this is a pain when giving orgs the right to manage their own users. Require users to specify their organisation at login time, probably with user@domain style logins, or ...


The following logins will be created on installation. They are containers for the accounts that the SQL Server Database Engine & Agent run under. [NT SERVICE\MSSQLSERVER] [NT SERVICE\SQLSERVERAGENT] The other accounts are groups that have been manually added into your SQL instance. BUILTIN\Administrators was installed by default in SQL Server 2005 ...

Top 50 recent answers are included