Re: windows NT authentication

From: BP Margolin (bpmargo@attglobal.net)
Date: 04/10/03 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Thu, 10 Apr 2003 01:41:56 -0400

Nikhil,

The issue of Windows vs. Mixed Authentication is not the issue here. Rather, you have users who have been given permissions independent of the application role. Adding an application role does not automatically remove other permissions. If you want to restrict these users, you have to remove the permissions granted to the users independent of the permissions in the application role.

 -------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Nikhil Mehrotra" <nikhil@rsd.4mis.com> wrote in message news:#l59y$x$CHA.824@TK2MSFTNGP11.phx.gbl...
> hi group,
>
> we have sql 2000 as a backend and vb application as a front end.
>
> We have implemented application roles on our database.
> Now, application roles are working perfectly allright, but what we recently
> saw was that some people who have the access to EM have connected to sql
> server thru windows NT authentication which means they can do the tasks for
> which they dont have ne right in the application role.
>
> We wud like to restrict the sql connectivity thru windows NT authentication.
>
> is it possible??
>
> --
> Regards,
> Nikhil Mehrotra
>
>
>

Relevant Pages

  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)
  • Re: Windows Authentication to SQL Server?
    ... oranges in trying to convert an asp.net app which uses forms authentication ... mode throughout the app with one SQL login account into SQL Server versus ... converting the asp.net app into a full individual Windows authentication ... Ultimate goal would be to see the individual windows ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: Integrated Authentication (Kerberos) Problem
    ... Verify the SPN for the SQL service account is registered such as the ... >Thread-Topic: Integrated Authentication Problem ... A Windows XP SP1 with IE6 client machine ...
    (microsoft.public.inetserver.iis.security)
  • Re: User authentication
    ... What I want to do is configure scheduled backup. ... However, if possible, I would like to use Windows authentication as opposed ... the backup job in SQL server. ...
    (microsoft.public.sqlserver.clients)
  • Re: How to SELECT records based upon ASP.NET Roles
    ... security principals directly. ... also be able to use SQL row-level security as well (which is something ... using Windows authentication in IIS, ...
    (microsoft.public.dotnet.security)
Quantcast