app role

We can use sp_setapprole to enable application role. How to disable the app
role?Once activated, it stays activated for the duration of the connection.
See the sp_setapprole topic in SQL Server Books Online for more
information.
--Mary
On Mon, 21 Nov 2005 11:19:10 -0800, Roy
<Roy@.discussions.microsoft.com> wrote:

>We can use sp_setapprole to enable application role. How to disable the app
>role?|||Roy (Roy@.discussions.microsoft.com) writes:
> We can use sp_setapprole to enable application role. How to disable the
> app role?
In SQL 2000, you cannot unset it.
In SQL 2005, you can use sp_unsetapprole for the task. You need to request
a coookie from sp_setapprole to do it.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx