Re: Database protection
From: Sophie Guo [MSFT] (v-sguo_at_online.microsoft.com)
Date: 09/15/05
- Previous message: Rene: "Re: Database protection"
- In reply to: Rene: "Re: Database protection"
- Next in thread: Uri Dimant: "Re: Database protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 15 Sep 2005 08:49:51 GMT
Hello,
You can use sp_grantlogin to allow a Microsoft Windows NT user or group
account to connect to Microsoft SQL Server using Windows Authentication.
Use sp_denylogin to prevent a Microsoft Windows NT user or group from
connecting to Microsoft SQL Server. For example, you can run
sp_denylogin 'builtin\administrators'
to prevent from administrator to connect to SQL Server. However, make sure
you have the SA password and the authentication mode is mixed-mode before
you do so.
For more information, refer to the following articles:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
sp_ga-gz_8dri.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
sp_da-di_9jji.asp
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
- Previous message: Rene: "Re: Database protection"
- In reply to: Rene: "Re: Database protection"
- Next in thread: Uri Dimant: "Re: Database protection"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
