Coldfusion Web appls from Oracle to SQL Server 2005 - How to use Application Roles in Coldfusion

Coldfusion Web appls from Oracle to SQL Server 2005 - How to use Application Roles in Coldfusion.

Is there anyone who has used application roles in Coldfusion Applications? How would you set this up?

I know how to set up application roles. If you establish your application role and you move from one page to another, how would you run cfquery since you loose your initial user connection in place of the application role connection. Are there alternatives to using application roles in Coldfusion?

Sample code would be helpful.

TF

There's not enough information here to help you - are you talking about SQL Server's application roles alone or how they interact from Oracle or Coldfusion? For general info, check here:

http://msdn2.microsoft.com/en-us/library/ms190998(SQL.90).aspx

|||

I want to find out how to use SQL Server 2005 application roles using Coldfusion MX as the application. I know how to use application role using a non-web based application. I do not know the issues involved with application roles using a web based application. We use Coldfusion to develop Web applications and we are wanting to use SQL Server 2005 as our database. We have to determine how our application security will work and we thought we could use application roles.

TF.|||SEe this http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18684&sliceId=1 is any use.