Re: Drop User Command

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/09/04

Next message: Rachan Terrell: "Best Way to Update Table?"
Previous message: Hugo Kornelis: "Re: Delete higher price record, if there is one."
In reply to: Brady Snow: "Drop User Command"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 9 Apr 2004 17:00:52 +0530

Hi,

In SQL Server you will be having Login and Users.

User: Who got previlege to access the databases

So before deleting the Login you have to drop the user

Command to drop user:

sp_dropuser <user_name>

Command to drop Login

sp_droplogin <login_name>

Apart from this refere the below commands in books online:

1. sp_revokelogin <Loginame>
2.sp_revokedbaccess <user_name>

Thanks
Hari
MCDBA

"Brady Snow" <anonymous@discussions.microsoft.com> wrote in message
news:1905501c41bee$fd37b770$a401280a@phx.gbl...
> What is the stored procedure for drop a user? Drop_user
> userx...
>
> Thanks,
>
> Brady Snow
> McKinney, Texas

Next message: Rachan Terrell: "Best Way to Update Table?"
Previous message: Hugo Kornelis: "Re: Delete higher price record, if there is one."
In reply to: Brady Snow: "Drop User Command"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: different environment fails to fill a dataset
... You might have lost the relationship of the Login to the user in the db. ...
Andrew J. Kelly SQL MVP ... oledbadapter.fill command to fill the dataset it fails.
... Is there anything in the environment or SQL Server that could be ... (microsoft.public.sqlserver.clients)
Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
... >> data and the SQL Server is on the same server. ... >> My problem
is that one user has started getting a login popup ... >> right in via Windows
Authentication like everyone else and like they ... (microsoft.public.sqlserver.connect)
Re: cannot acees two databases as owner
... it does not matter you are a member of the ... the sysadmin fixed server
role or if there is no any other Login which is ... group if it's a domain) and you
can login to your SQL Server with, ... (microsoft.public.sqlserver.setup)
Re: Database security design with ASP.net and form-based authentication
... Since you already have forms-based security, why not use a single SQL login ...
for all database access? ... data entry, guest/view only, admin, report viewer.
... so I'm using SQL Server authentication. ... (microsoft.public.sqlserver.security)
Re: Credentials not being passed with remote access
... allowed windows authentication to work, ... I had assumed johnx was a
domain user rather than a local Windows account. ... johnx was set up as a local login
on sql server. ... (microsoft.public.sqlserver.security)