Re: removing old logins

From: Dan D. (DanD_at_discussions.microsoft.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 06:28:04 -0700

I understand. Makes perfect sense.

Thanks, 

-- 
Dan D.
"Hari Prasad" wrote:
> Hi,
> 
> This error will come when the user has been allocated permissions to some
> other databases. So you have to
> drop the user associated to that login from all the databases and then drop
> the login.
> 
> Command to get the databases user is mapped
> 
> sp_helplogins  <logn_name>
> 
> Then use have to go to each database and drop the user
> 
> use <dbname>
> go
> sp_dropuser <user_name>
> 
> Once you drop the user from all the databases you could drop the login..
> 
> sp_droplogin <login_name>
> 
> Thanks
> Hari
> MCDBA
> 
> 
> 
> "Dan D." <DanD@discussions.microsoft.com> wrote in message
> news:DC4A9B5E-2EB5-40E6-9BD1-F4A9AC51E63D@microsoft.com...
> > Using SS2000. I'm removing old logins. When I tried to remove one, I
> received this message "removing tis login will remove all associated
> database users (if any)."
> >
> > What does this mean?
> >
> > Thanks,
> > --
> > Dan D.
> 
> 
>

Relevant Pages

  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... detected that this login has permissions....etc this login ... be mapped to dbo. ... sysusers in the user databases and syslogins in master. ... I have seen a windows group referred to as a LOGIN for sql server in the ...
    (microsoft.public.sqlserver.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... any of the databases. ... exist anywhere in sql server either. ... detected that this login has permissions....etc this login ... be mapped to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)
  • Re: Random Login Failures
    ... setup a trace in Profiler to collect failed logins with these columns ... Analzy the trace after some failed login may help. ... that later I found out a report queried ALL user databases instead SOME ... primary database server hosting about 50 or so databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Lost ability to login to secure database
    ... > to login and cannot open any of my secured databases. ... I assume you know the workgroup file that was used to secure your ... Create a desktop shortcut to open them. ...
    (microsoft.public.access.security)
Loading