• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

system_user for a user without login

create user test without login
execute as user = 'test';
select system_user
revert
drop user test

when i run the above, i get the value of
S-1-9-3-2009668872-1126946027-3271010458-694455781
which i can't see in sysusers or syslogins.. what is it?

thanks
0
anushahanna
Asked:
anushahanna
  • 3
2 Solutions
 
Chris MangusDatabase AdministratorCommented:
It's showing you a SID of an orphan user, which is a user account without a login.
0
 
anushahannaAuthor Commented:
But could not see it in sysusers (that id starting with S-') rather we have a regular sid

create user test without login
execute as user = 'test';
select system_user
select * from sysusers where name = 'test'
revert
drop user test
0
 
Scott PletcherSenior DBACommented:
My best guess is that SQL may have to create some type of login name internally because of the way its processes work.  You're likely seeing that "dummy" login name.
0
 
anushahannaAuthor Commented:
OK. that makes sense.
0
 
anushahannaAuthor Commented:
Thank you for your input.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now