Website, AD user -> ROLE -> sql Server question

From: sqlServerQuestion (anonymous_at_discussions.microsoft.com)
Date: 01/28/04 

Date: Tue, 27 Jan 2004 16:56:05 -0800

Hello - users enter corporate intranet site and the application gets their user name from AD. Then it needs to connect to Sql Server and pass
(1) either a user name or
(2)SQL server role name that user belongs to (if he does)

This way only authorized users who've been added to the role will have alter permissions on tables.

Is this approach correct? How do I do this?
Please help. Thank you.

Relevant Pages

  • Re: Minimum Permissions for sp_adduser
    ... But the OP is using SQL Server 2000 ... I suggested to him adding the user into securityadmin server role and try ... But still i am not able to execute sp_adduser using this new user. ... stored procedure will not add the rights to a non-dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: Server role for starting SQL Server Agent
    ... > What server role do I need to give the ID that will ... > start/shut down the SQL Server Agent? ... usually you'll need an account (usually a domain account) with enought ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.security)
  • Re: Security for Jobs
    ... >program to run the sql server job. ... >> restart jobs when failure has occurred. ... >> are part of the 'Systems Administrators' Server Role ... >> Does anyone know of the correct permission to allow ...
    (microsoft.public.sqlserver.security)
  • Re: users require SQL admin but not server admin ?
    ... server role in SQL Server, without making them a part of local admins group ... on the box, or domain admins. ... Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.server)