Problem with application roles 
Author Message
 Problem with application roles
I have created an application role for an application and the
application role has permissions to access and update certain tables in
the database that the application has to access But not sure if i can
assign user accounts as members of the application role and how i can
let my application access the database using this application role

any ideas?

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Wed, 21 Dec 2005 09:58:22 GMT
 Problem with application roles

You invoke this with the sp_setapprole stored procedure.  The entry in
BooksOnLine describes how to use this properly.

--

Andrew J. Kelly
SQL Server MVP


Quote:
> I have created an application role for an application and the
> application role has permissions to access and update certain tables in
> the database that the application has to access But not sure if i can
> assign user accounts as members of the application role and how i can
> let my application access the database using this application role

> any ideas?

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Wed, 21 Dec 2005 15:48:45 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problems using application role.

2. Application Roles and Server Roles

3. Application Roles and Server Roles

4. Security-problem Application role

5. problem while connecting to sqlserver using application role with asp

6. Application Roles - problem

7. Application role problems

8. Problems with SQL Server application roles and ADO on IIS

9. Problem with permissions/application roles

10. Application Role Problem SQL 7

11. Problems using SQL Server application roles (long)

12. Problems with SQL Server application roles and ADO on IIS


 
Powered by phpBB® Forum Software