Re: Windows Services Groups

Hi Hari,

In the first place, I would recommend that you do not delete any logins that
you already have created.

To make sure that your network admins don't have access to SQL Server, simply
revoke login privileges to their accounts.

As it was in the SQ: Server 2000 world, one would use the

sp_revokelogin or sp_denylogin to the respective Windows Domain\User

The link below should be handy :)

http://doc.ddart.net/mssql/sql70/sp_da-di_21.htm

Hope this helps :)

--
Best Regards

Anil Mahadev

http://anilm001.myfreewebs.net/index2.php

http://www.db2india.org

Message posted via http://www.sqlmonster.com

.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)
  • Re: Windows permissions to run Jet OLEDB 4.0
    ... in SQL Server or not when you have to go outside of the server to the ... Actually I was talking about Windows logins. ... There is no security whatsoever implemented on the mdb ...
    (microsoft.public.data.oledb)
  • Re: Logins & Permissions
    ... At server level, we use "Logins" to connect to a SQL Server Instance and perform server level jobs. ... "Users" are used and these users are mapped to Logins. ... I am using SQL Server 2005 on a Windows NT Network ...
    (microsoft.public.sqlserver.security)
  • No Application Logins Allowed - SOX
    ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
    (microsoft.public.sqlserver.security)