Active Directory Security Group versus Login

I am not sure if this is the right group to post my question but I hope
someone can give my advise.

For ease of management, I created a security group account in Active
Directory and assigned authorized domain users in it. I then granted this AD
group to have CONTROL of the SQL certificate and able to open symmetric key
encrypted under this certificate.

I hope to use this AD group to open the symmetric key from SQL 2005
Reporting Service. I granted SQL Reporting to this AD group so that these
users can run the SQL Reporting Service reports. However, I was unable to
find a way to pass this AD group to SQL store procedure so that SQL can use
this AD group to open the symmetric key to display decrypted data.

Is this possible? If so, it will reduce creating individual login, user and
table permission in SQL. This would be a big help to reduce DBA users
management.

Brian
.

Relevant Pages

  • URGENT PROBLEM PLEASE HELP US
    ... We are installing the final release of SQL 2005 On our main SQL server. ... Setting reporting service and share point exclusion path. ... Errore irreversibile durante l'installazione. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL report tools
    ... And it's good to know that Reporting Service will come with SQL. ... > If you have Microsoft Office, you could use Microsoft Access to do ... > a web server and a SQL Server all on the same box. ...
    (microsoft.public.sqlserver.tools)
  • Re: Can VS2005 express can use the reporting service in SQLSever 2005 express
    ... Reporting Services in sql 2005 express. ... >I found that there is reporting service bundle with SQLSever 2005 express. ...
    (microsoft.public.dotnet.framework.aspnet)
  • how to generate barcode label in asp.net
    ... How to generate barcode label in asp.net? ... I am using MS SQL ... can reporting service in MS SQL do that? ... Regards, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sql Mobil (SqlCE 3.0) and Full Framework
    ... Yes I'm using Sql2005 Management Studio with replication and that is the ... > SQL Mobile database. ... > would on the device *except* you bring in a reference to the desktop ...
    (microsoft.public.sqlserver.ce)