dropped users still show up in public role

From: Darrell (darrell.eldridge@adtran.com)
Date: 05/16/02 

From: darrell.eldridge@adtran.com (Darrell)
Date: 16 May 2002 07:24:14 -0700

I have SQLServer 7.00.623 -- a development copy (i.e., one I use for
development, not production). Using the Enterprise Manager I deleted
all logins and users (except dbo and sa, of course), but they still
show up in the public role (listed in the properties), and the Remove
button is disabled. Now if I try to create a new login with the same
name as a deleted login, I get the error "User or role 'xxx' already
exists in the current database." How can I synchronize the public
role with the existing users/logins?

Relevant Pages

  • Tale of debugging and programming logic in c#/sql
    ... Just finished off a production .NET web application written in c#. ... I set up a error handler in the global.asax which is triggered to iterate ... My error handler email shows two session variables ... The login page was written poorly -- it was from an ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Tale of debugging and programming logic in c#/sql
    ... > and I pushed it to production. ... I was anxious to find a fix, ... The login page does ... > user authenticates or creates a new login name -- it is based on an ID ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: New DBs DBO does not have an associated login name
    ... But under Enterprise Manager when I drill down to ... the DB and select users the DBO has no associated logon. ... > SQL Server MVP ... >> does not have an associated login name. ...
    (microsoft.public.sqlserver.setup)
  • Re: WIN2K Pro cannot login to domain (In-place upgrade to 2003 R2 from NT4.0)
    ... Original PDC is in the production NW ... When you take TBDC offline and upgrade it to PDC, can all clients login ... WIN2K Pro cannot login to domain (In-place upgrade to 2003 R2 ...
    (microsoft.public.windows.server.migration)
  • Re: dropped users still show up in public role
    ... Enterprise Manager won't let you drop orphaned users. ... >development, not production). ... >show up in the public role, ... Now if I try to create a new login with the same ...
    (microsoft.public.sqlserver.security)