Re: Creating new user default to DB_owner role

Jacgues
Wait, lets do it step by step. If I create a sql login (via SSMS) it does
not happen assign db_owner role, perhaps you meant when you try to map the
logi to the user on one of the database? Then it gets dbo as default schema
, but it is not a memeber of db_owner role. is it?




"Jacques" <Jacques@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95CCA687-96A2-4CA3-ACC5-D8B1DA7099B1@xxxxxxxxxxxxxxxx
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.

Any suggestions?



.

Relevant Pages

  • Re: SSMS problem display database list on remote server
    ... Actually I just noticed that you are using SSMS Express, ... SSMS Express have an Object Explorer Details pane? ... SSMS Express 2008 to access our database on ... the server of our hoster. ...
    (microsoft.public.sqlserver.tools)
  • Re: SSMS problem
    ... I have both VS and SSMS on a number of machines, and I don't use VS to manage my databases. ... I'd check of you have the exe file for SSMS installed. ... I found out that the reason SSMS is not showing up is because Visual Studio 2005 is installed and you have to use its software to deal with the database. ... The other problem is adding a new user to SQL server for the purpose of having a web site that uses that database. ...
    (microsoft.public.sqlserver.tools)
  • Re: SSMS problem
    ... Studio 2005 is installed and you have to use its software to deal with ... the database. ... I have both VS and SSMS on a number of machines, ... C:\Program Files\Microsoft SQL ...
    (microsoft.public.sqlserver.tools)
  • Re: Opening large databases in Query Analyzer
    ... Are you using SSMS or SSIS? ... I would definitely be interested in how the database is ... Server Compact Edition Query Analyzer on a handheld device? ...
    (microsoft.public.sqlserver.ce)
  • SSMS - setting root of Object Explorer
    ... I'm slowly coming to terms with the SQL Server Management Studio 2005. ... but cannot figure out how to restrict the SSMS to ... only look at one database. ... If setting the Object Explorer root is not possible, ...
    (comp.databases.ms-sqlserver)