SQL Server 2005 introduces a new type of database user, one that is
created using the "WITHOUT LOGIN" clause. This user is not mapped to a
login, and is being touted as an alternate to Application Roles
because no password is needed.. What I do not understand is how to use
this type of user. I know how to use sp_setapprole with Application
Roles, what are the equivalent steps needed to use login-less users?
Thank you in advance.
Terry Duffy
You use it with EXECUTE AS. This blog entry has a demo
walking through how to use similar to an application role.
http://blogs.msdn.com/raulga/archive/2006/07/03/655587.aspx
-Sue
On 12 Apr 2007 14:44:27 -0700, "Terry" <tduffy@.calamos.com>
wrote:
>SQL Server 2005 introduces a new type of database user, one that is
>created using the "WITHOUT LOGIN" clause. This user is not mapped to a
>login, and is being touted as an alternate to Application Roles
>because no password is needed.. What I do not understand is how to use
>this type of user. I know how to use sp_setapprole with Application
>Roles, what are the equivalent steps needed to use login-less users?
>Thank you in advance.
>Terry Duffy
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment