locked
Application Roles - changing password RRS feed

  • Question

  • Hello,

     

    in SQL Server 2005 I have an application role that is being used to limit access to my server data from third party applications. Everything is working well, except changing the Application role password.

    I set up a small form that allows an administrator to change the App Role password through the front end app. I cannot, however, seem to get the Password field in my approle to accept a parameter.

    For example:

    declare @newpassword varchar(128)

    set @newpassword = 'foo'

    ALTER APPLICATION ROLE MyApplicationRole

    with PASSWORD = @newpassword

    This procedure gives me a syntax error in the last line. It will accept a string in quotes but not a varchar parameter.

     

    Ideas?

    Tuesday, March 13, 2007 11:29 PM

Answers

All replies