Re: How to obtain credentials to access a Windows authenticated databa




"Ron James" <RonJames@xxxxxxxxxxxxxxxxxxxxxxxxx> skrev i en meddelelse
news:54D749E0-4642-4DA1-A004-EB46C62007E2@xxxxxxxxxxxxxxxx
Now we've switched the DB to Windows Authentication, the users credentials
are being used to access the Database

Ok.

and this is failing because these users
are denied direct access to the database. (Previously our software was
looking up DB username/password).

Then grant them access. Stuff the users in a group and give the group access
to the database.

I'm looking for a solution that allows us to use Windows Authentication to
the database and allows us to restrict the Admin web site to selected
individuals.

Just don't put Everyone in the group.
Or stop them before they reach the database, by disallowing them access to
the web-site. And hope they dont access the database directly instead of
going through the web-site.

/jim


.



Relevant Pages

  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: oracle XE impdp.exe problem
    ... I did my own - ora. ... I created new tablespace and user xxx as: ... GRANT UNLIMITED TABLESPACE TO xxx; ... when i create new database i have this strange error. ...
    (comp.databases.oracle.server)
  • RE: all operation not work (insert delete update) / maybepermissionproblem
    ... The database server cannot find a table or view specified in the statement. ... trying to grant USAGE privileges on a user-defined type. ... Betreff: Re: all operation not work / maybe permissionproblem ... I called this command just you are told me: onstat -g sql and I got the following: ...
    (comp.databases.informix)
  • Re: all operation not work (insert delete update) / maybepermissionproblem
    ... The database server cannot find a table or view specified in the statement. ... trying to grant USAGE privileges on a user-defined type. ... Betreff: Re: all operation not work / maybe permissionproblem ... I called this command just you are told me: onstat -g sql and I got the following: ...
    (comp.databases.informix)
  • Re: Simple SQL Security Question From SQL Newbie
    ... >exec sp_grantdbaccess 'WIN2K\ASPNET' ... >VS.NET, I can use the server explorer and I can see the database, it's ... >login 'WebCalendar'. ... I also did a GRANT ALL on y2003 TO ASPNET ...
    (microsoft.public.sqlserver.security)