Re: SQL Server Application Roles

From: Jonathan Allen (x_at_x.x)
Date: 11/19/05

  • Next message: luxspes: "Re: SQL Server Application Roles" 
    Date: Sat, 19 Nov 2005 14:43:38 -0800

    Allow me to restate my question.

    What the hell is the right way to use application roles from VB/C#? When I
    try the below code, I get an exception the second time I call
    GetDBConnection. 

    -- 
Jonathan Allen
"Jonathan Allen" <x@x.x> wrote in message 
news:eF4AhZV7FHA.472@TK2MSFTNGP15.phx.gbl...
> Is this the correct way to use application roles?
>
> Public Function GetDBConnection() As SqlConnection
>    Dim oCon As New SqlConnection(myConnectionString)
>    oCon.Open()
>    Using oCmd As SqlCommand = oCon.CreateCommand
>        oCmd.CommandText = "IF NOT User_NAME() = 'app_name' Exec 
> sp_setapprole 'app_name' ,'password"
>        oCmd.ExecuteNonQuery()
>    End Using
> Return oCon
>
> What is a good way to embed/encrypt the application role's password in the 
> program?
>
> -- 
> Jonathan Allen
>
>
>
>
  • Next message: luxspes: "Re: SQL Server Application Roles"