Creating new user default to DB_owner role

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: Creating 3.5 databases ?
    ... You can create the database using the Server ... Tables node and right click to add tables.(Or use SSMS.) Then use Data ... It automagically creates the TableAdapter ... I also cannot reference it in code as it tells me it cannot find ...
    (microsoft.public.sqlserver.ce)
  • 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: SQL Server Management Studio Cannot Open SQL Express Files
    ... Currently I can work with the DB in SSMS but not in VS. ... I suggest you to open SQL Server Configuration Manager and see how many SQL ... If I create the database in VS2005 using the ... If I create the DB in Management Studio I cannot work with it in VS2005. ...
    (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: Creating 3.5 databases ?
    ... Can you open a database with tables created using the VS designer in SSMS for example and vice versa? ... Device Application Development MVP ... What I am saying that tables created with SSMS are visible to my code and automatically get TableAdapters when added. ... I also cannot reference it in code as it tells me it cannot find the table. ...
    (microsoft.public.sqlserver.ce)