Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Can we make use of user without login.. Expand / Collapse
Posted Friday, August 16, 2013 3:14 AM


Group: General Forum Members
Last Login: Wednesday, June 15, 2016 11:01 PM
Points: 120, Visits: 470
Hi All,

Can you please suggest...Can we create user without login and what is the use for this if we can create user without login...

Post #1485047
Posted Friday, August 16, 2013 4:40 AM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:29 AM
Points: 889, Visits: 862
Yes, you can say:


Like any good feature, this has a multitude of use cases. Here are a few:

1) You don't want to grant end users direct access to SQL Server, so you use an application login. However, you want to be able to audit who is doing what, why the application performs EXECUTE AS = 'User' and you create loginless users in the the database.

2) You want to use the EXECUTE AS clause to package permissions in stored procedure. Rather than the casual EXECUTE AS OWNER, you should use EXECUTE AS 'loginlessuser' where the user has only been granted the permissions needed to run the stored procedure.

3) You use Service Broker and activation procedures which you want to run in a controlled context. Loginless users which has been granted restricted rights come in handy here.

Erland Sommarskog, SQL Server MVP,
Post #1485094
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse