Does SQL's sp_setapprole work in ASPDB

[Thomas Brown]

I'm using an application role in SQL and I'm geeting a permissions problem while attempting to insert a new record while using ASPDB. Is there a way to run "sp_setapprole" in ASPDB. I don't have this problem outside of ASPDB. Can you help?

Tom

[John]

Hi Tom,

You can use dbSilentCmdText to issue SP or SQL cmds to set the permissions as necessary for the SQL query to run.

John


------------
Thomas Brown at 9/11/2002 12:44:10 PM


I'm using an application role in SQL and I'm geeting a permissions problem while attempting to insert a new record while using ASPDB. Is there a way to run "sp_setapprole" in ASPDB. I don't have this problem outside of ASPDB. Can you help?

Tom