Re: Creating new user default to DB_owner role
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 27 Mar 2008 16:21:12 -0700
Jacques (Jacques@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
When I create a new SQL login via SSMS the user gets assigned db_owner
role by default. This only happens on the one database.
Removing the db_owner role during creation of the user causes SSMS to
fail with an error because it tries to remove the user that is being
created from the db_owner role.
A DDL trigger that adds all new users to db_owner?
Does the same happen if you run CREATE USER from a query window?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Creating new user default to DB_owner role
- From: Jacques
- Creating new user default to DB_owner role
- Prev by Date: Re: Login Error 18456
- Next by Date: Little database user account script need help...
- Previous by thread: Re: Creating new user default to DB_owner role
- Next by thread: RE: What tools do you use to comply with Sarbanes-Oxley?
- Index(es):
Relevant Pages
|
|
