custom security extension

Hello,
i tried the sample for the custom security extension for sql server 2005.
the c# Version worked, the vb.net version does not!
Is there another example with the use of application roles? We need this for
reporting issues.
thx in advange
michaelHi michael,
Welcome to use MSDN Managed Newsgroup Support.
I am not so sure which sample application you can not deploy. Would you
please post the Application path here?
As for the samples of Application Role, you may try to refer SQL Server
books online.
An application role is a database principal that enables an application to
run with its own, user-like privileges.
The following steps make up the process by which an application role
switches security contexts:
A user executes a client application.
The client application connects to an instance of SQL Server as the
user.
The application then executes the sp_setapprole stored procedure with
a password known only to the application.
If the application role name and password are valid, the application
role is activated.
At this point the connection loses the permissions of the user and
assumes the permissions of the application role.
For more detail information, you may refer the following article:
Application Roles
http://msdn2.microsoft.com/en-us/library/ms190998(SQL.90).aspx
CREATE APPLICATION ROLE
http://msdn2.microsoft.com/en-us/library/ms181491(SQL.90).aspx
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei,
I tried this sample application:
c:\Program Files\Microsoft SQL Server\90\Samples\Reporting
Services\Extension Samples\FormsAuthentication Sample\cs\FormsAuthentication
It worked for me, but i need the ability to work also with Roles (instead of
NT Group names).
Is there a sample application which consider application roles to group
users with identical permissions for a Custom security extension for sql
server 2005?
thx
michael
"Wei Lu" wrote:
> Hi michael,
> Welcome to use MSDN Managed Newsgroup Support.
> I am not so sure which sample application you can not deploy. Would you
> please post the Application path here?
> As for the samples of Application Role, you may try to refer SQL Server
> books online.
> An application role is a database principal that enables an application to
> run with its own, user-like privileges.
> The following steps make up the process by which an application role
> switches security contexts:
> A user executes a client application.
>
> The client application connects to an instance of SQL Server as the
> user.
>
> The application then executes the sp_setapprole stored procedure with
> a password known only to the application.
>
> If the application role name and password are valid, the application
> role is activated.
>
> At this point the connection loses the permissions of the user and
> assumes the permissions of the application role.
> For more detail information, you may refer the following article:
> Application Roles
> http://msdn2.microsoft.com/en-us/library/ms190998(SQL.90).aspx
> CREATE APPLICATION ROLE
> http://msdn2.microsoft.com/en-us/library/ms181491(SQL.90).aspx
>
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Michael,
I understand that you want to use application roles for a custom security
extension for SQL reporting services. If I misundestood your concern,
please feel free to point it out.
Application Role is a database principal that enables an application to run
with its own, user-like privileges. So Application Role is a database
security. And I think it is not suitable for the Reporting Service.
If you use application role to control the permission of SQL database then
you can not control the authentication of the Reports in the report server.
Thank your for your understanding.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.