Solved

system_user for a user without login

Posted on 2010-09-09
5
307 Views
Last Modified: 2012-05-10
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
Comment
Question by:anushahanna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 250 total points
ID: 33639761
It's showing you a SID of an orphan user, which is a user account without a login.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33639830
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
 
LVL 69

Assisted Solution

by:Scott Pletcher
Scott Pletcher earned 250 total points
ID: 33640430
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
 
LVL 6

Author Comment

by:anushahanna
ID: 33640481
OK. that makes sense.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33640486
Thank you for your input.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Where clause to fliter varchar with Characters 12 58
What is needed to become a DBA? 7 55
SQL Query 9 27
Populate fields in group based on first record in group 4 11
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question