December 28, 2017 at 2:23 pm
Hi All,
Today, I came across a term which I wasn't aware of all these days.
What is login less user in sql server? what are these ? How to create them and when do we use it (i mean what are the use cases for login less users)?
From which SQL Server version , we have these users?
Thanks,
Sam
December 28, 2017 at 2:58 pm
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
December 28, 2017 at 9:08 pm
Drew.. Link doesn't work !
December 29, 2017 at 3:11 am
Thom A - Friday, December 29, 2017 2:06 AMvsamantha35 - Thursday, December 28, 2017 9:08 PMDrew.. Link doesn't work !It doesn't? Works fine for me. The animation is quite enjoyable. 🙂
There may be a lack of patience involved 🙂
...
December 29, 2017 at 5:21 am
Slowly realized that the animation is pointing out to google search. Anyways thanks. Basically looking for any specific scenarios / use cases of using those login less users.
December 29, 2017 at 6:20 am
Apparently, you need some more help. Once you do the Google search, you need to open the links. Here are the first three that I got.
https://blog.sqlauthority.com/2012/10/04/sql-server-importance-of-user-without-login-t-sql-demo-script/
which is a complement to this one: https://blog.sqlauthority.com/2012/09/29/sql-server-importance-of-user-without-login/
The second one is from this site http://www.sqlservercentral.com/articles/Security/101696/
The third one is from the Microsoft forums https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7d129880-048c-4834-a72e-c31ead4897cb/database-user-without-login?forum=sqlsecurity
All of them have description of uses for the loginless users. There's no reason to explain them here again.
December 29, 2017 at 7:49 pm
vsamantha35 - Thursday, December 28, 2017 2:23 PM(i mean what are the use cases for login less users)?
It's great for testing before you "go live" and is an alternate method for assigning permissions where procs can use EXECUTE AS. You simply create a user in a database WITHOUTLOGIN and go from there.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply