Mapping Active Directory Group members to SQL Server Roles

My question is I have a SQL Server running on Web Server which is a member of a 2000 Active Directory, I only grant access to the database via Global Groups from the Active Directory. When I log onto the database via Windows Authentication the actual user shows up in the master.dbo.sysprocesses table, I can tell what database that process is going to but not how that user is being translated to the Global Group that was actually given access. I need the actual database user name which is the Global Group name that had permissions granted via user defined database roles so that I can do some pre-processing in an ASP.NET application so that I know what parts of a form are updatable or not.No, a Server Role container for users with a specific set of permission. The group has to be mapped to a principal in SQL Server to be included in a role.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.desql

Managing Permissions

I am having trouble managing permission and am looking for a solution. My
databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by 3
inch window to check and uncheck table/Column permissions. This is
frustrating!!! Is this data held in one of the system tables? Is there som
e
additional software to handle this?Hi,
See "GRANT" and "REVOKE" commands in SQL Server Books online.
Thanks
Hari
SQL Server MVP
"Matt Sonic" <MattSonic@.discussions.microsoft.com> wrote in message
news:3F3DE2FD-C2F3-4DA3-849F-1F7BC167B87F@.microsoft.com...
>I am having trouble managing permission and am looking for a solution. My
> databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by
> 3
> inch window to check and uncheck table/Column permissions. This is
> frustrating!!! Is this data held in one of the system tables? Is there
> some
> additional software to handle this?|||Check out http://www.agileinfollc.com DataStudio
"Matt Sonic" <MattSonic@.discussions.microsoft.com> wrote in message
news:3F3DE2FD-C2F3-4DA3-849F-1F7BC167B87F@.microsoft.com...
>I am having trouble managing permission and am looking for a solution. My
> databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by
> 3
> inch window to check and uncheck table/Column permissions. This is
> frustrating!!! Is this data held in one of the system tables? Is there
> some
> additional software to handle this?

Managing Jobs - server roles

Hello,
What server/permission role can i assign a user so he can use SQL
agent/management and see that jobs have run, created etc without assigning
him system admin. The most restrictive yet allowing him to see the jobs
thanksHi,
A user who is not a member of the sysadmin fixed role can use sp_help_job to
view only the jobs he/she owns.
Thanks
Hari
"Charlie" <Charlie@.discussions.microsoft.com> wrote in message
news:4DAEB3D9-4FA6-41C0-BCF3-E0795BFC1031@.microsoft.com...
> Hello,
> What server/permission role can i assign a user so he can use SQL
> agent/management and see that jobs have run, created etc without assigning
> him system admin. The most restrictive yet allowing him to see the jobs
> thanks