Re: Removing Windows User from the Security folder

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 02/11/04 

Date: Tue, 10 Feb 2004 23:15:18 -0000

See sp_revokelogin in Books On Line, sp_droplogin is for SQL logins. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Scott" <scasti1@cox.net> wrote in message
news:E38AC590-50C0-44B3-BDA2-91FCC0E43CB3@microsoft.com...
> Can't seem to locate the stored procedure for removing a Windows
Authenticated User from the Security folder.
>
> sp_droplogin   doesn't seem to work.  It only works on SQL Logins.
>
> Can't find what appears to be proper procedure in Master database.
>
> What I get is the message "The Login [login name] doesn't exist".
>
> Thanks for any help.
>
> Scott
>
>

Relevant Pages

  • Domain Collapse. Sql permission question.
    ... Internally sql server uses SID of NT users to link them ... with sql logins. ... change users display name. ...
    (microsoft.public.sqlserver.server)
  • Re: How can I secure a MSDE database for users who have SQL Server?
    ... SEM does not give anyone rights that they do not already have. ... or DENY rights to the appropriate users (whether SQL Logins or ... Windows accounts) and they will see only what you want them to see. ... > How can I protect a MSDE-database so that SQL Server Enterprise ...
    (microsoft.public.sqlserver.security)
  • Re: 1 server 2 SQL apps
    ... have such service so you have to stop the SQL Server service? ... >>It is possible to set up security at the server level (SQL Logins, ... Application roles) and assign the approrpiate ones to each database ... Of course you will have separate stored procedures within ...
    (microsoft.public.sqlserver.server)
  • Re: 1 server 2 SQL apps
    ... if you are purchasing the standard ... >edition of SQL Server it is my understanding that you will have to purchase ... >It is possible to set up security at the server level (SQL Logins, ... Application roles) and assign the approrpiate ones to each database ...
    (microsoft.public.sqlserver.server)
  • Removing Windows User from the Security folder
    ... Can't seem to locate the stored procedure for removing a Windows Authenticated User from the Security folder. ... It only works on SQL Logins. ...
    (microsoft.public.sqlserver.security)
Quantcast