Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NT Authentification vs SQL logins
Message
From
17/05/2002 15:36:59
 
 
To
17/05/2002 13:26:42
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
00657968
Message ID:
00658396
Views:
37
>I've had this conversation with my boss and he wants to go NT auth. and I prefer using SQLs. The idea is that by using NT authentication (if you are a heavy microsoft shop like we are) you keep all of the permissions management in one place. A simple front line support person can manage the rights rather then the SQL administator having to do it.

I almost agree with you here. It is true that all permissions are co-located but, regarding SQL Server, those permissions are limited to accessing the server or not. Permission within the database must still be managed from within SQL Server and not the domain.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform