Re: Creating new user default to DB_owner role

Hi Uri
You are right, when mapping the new login to a user in the database it gets
assigned the dbo schema. This is correct. However, in this instance the user
gets the db_owner database role and public database role as the default roles.

My understanding is that it should only get public as the default role.

"Uri Dimant" wrote:

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: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Enter user name, enter password, then press enter...
    ... What do you do when the customer asks that the database login in be the same ... username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ...
    (microsoft.public.access.forms)