Re: Role activation
From: Mary Chipman (mchip@nomail.please)
Date: 03/27/03
- Next message: Arnaldo Martinez: "VB6, SQL, CR7 and Windows 2000/NT Please Help!!!!!"
- Previous message: Edwin Gibbs: "Securing SQL Server with IIS 6.0"
- In reply to: Darko Grujic: "Role activation"
- Next in thread: Darko Grujic: "Re: Role activation"
- Reply: Darko Grujic: "Re: Role activation"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Mary Chipman <mchip@nomail.please> Date: Thu, 27 Mar 2003 14:24:35 -0500
Are you sure? How are you verifying that it didn't get activated on
that connection? You can select the USER or USER_NAME to verify--it
should change to the role name. Bear in mind that approles are
connection-specific, and unless you turn off connection pooling in
your connection string, it might not be active. see this link for more
info:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q229564
-- Mary
MCW Technologies
http://www.mcwtech.com
On Thu, 27 Mar 2003 03:59:53 -0800, "Darko Grujic"
<darkogrujic@hotmail.com> wrote:
>I can activate an application role using Query Analyzer
>with EXEC sp_setapprole "RoleName", "RolePassword"
>but not using VBA from within Excel or from within another
>application:
>
> Dim oConnection As ADODB.Connection
>' Create the connection object and connect.
>Set oConnection = CreateObject("ADODB.Connection")
>oConnection.Provider = "sqloledb"
>oConnection.Open "Server=SERVERNAME;Database=pubs;Trusted_C
>onnection=yes"
>
>' Activate the application role. There is no error
>handling for this sample.
>oConnection.Execute "EXEC
>sp_setapprole 'AccAppRole', 'ABC'"
>
>This runs with no errors, all libraries exist, but the
>role does not get activated.
- Next message: Arnaldo Martinez: "VB6, SQL, CR7 and Windows 2000/NT Please Help!!!!!"
- Previous message: Edwin Gibbs: "Securing SQL Server with IIS 6.0"
- In reply to: Darko Grujic: "Role activation"
- Next in thread: Darko Grujic: "Re: Role activation"
- Reply: Darko Grujic: "Re: Role activation"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
