Re: Delete a user. Please help

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/09/05 

Date: Wed, 9 Mar 2005 13:19:32 +0100

Do what the error message say: Remove the users or aliases from the database as listed in the error
message.
If these are users, use sp_dropuser for if it is a SQL Server Login or sp_revokedbaccess if it is a
Windows Login.

If these are aliases (which i think it is, as EM doesn't remove them for you), use sp_dropalias.

The stored procedures I mentioned above are documented in Books Online. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"George D. Lake" <NoSpam@bla.com> wrote in message news:eJuY4$JJFHA.3340@TK2MSFTNGP14.phx.gbl...
> Hi,
>    I hve been tring to delete a Login User form SQL 2000 and cant do it
>    I go to Security, Logins, find the user, right click and delete.
>
>    I then get a option that says "Removing this login will remove all associated database users 
> (if any)".
>    I say yes to that and then...
>    Error 15174: Login 'XXXXXXX' is aliased or mapped to a user in one or more databases- Drop the 
> user or alisas before dropping the login.
>    Database name :DB1, DB2, DB·, etc.
>
>
>    How can I get past this!
>
>
> Thanks.
> George.
>
>

Relevant Pages

  • Re: SQL Express Login Failed - error 18456 state 16
    ... State 16 means the login can't log into the target database. ... I have searched MSDN for the error message and just find forum posts with no ...
    (microsoft.public.sqlserver.security)
  • Re: login and password administration
    ... After adding the current owner of the object, now I get this error message: ... User or role 'sa' does not exist in this database. ... We have several web sites each with its own login and password. ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot view results of query
    ... > login to the database and view the results, ... This implies that the query runs, but only an hourglass is displayed. ... suspect instead that there is a specific error message when these users ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Account Dropped but Public Role still shows account?
    ... I'm not sure where you are looking at this - server roles or ... A user can have another name in a database - ... >> user then drop the login if needed. ... >> the error number and error message you get when you try to ...
    (microsoft.public.sqlserver.security)
  • Re: Changing the Database Owner
    ... When you issue sp_changedbowner 'NewLogin' does it indeed change the owner? ... the @map argument to remap those aliases to the new owner. ... > the error that "..The proposed new database owner is ... > owner the new login and changing it back, ...
    (microsoft.public.sqlserver.security)
Loading