How to Use Login-Less Users as Alternate to Application Roles

  • 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

  • I found this blog entry that has some examples of this:

    http://blogs.msdn.com/raulga/archive/2006/07/03/655587.aspx

    Greg

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply