Solved

execution context - token

Posted on 2010-08-12
3
541 Views
Last Modified: 2012-05-10
Hi experts, i am reading about execution context, but i don't understand a login token ( sys.login_token)  and a user token(sys.user_token).
I need an example (like a hands on lab) in which they explain the diference between these two token
0
Comment
Question by:enrique_aeo
[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 Comments
 
LVL 9

Assisted Solution

by:Sreedhar Vengala
Sreedhar Vengala earned 100 total points
ID: 33425747
Look into this http://www.sommarskog.se/grantperm.html got details explanation of sys.login_token and sys.user_token
0
 

Author Comment

by:enrique_aeo
ID: 33431519
Please experts, I need something more precise, an example would be excellent transact sql
0
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 400 total points
ID: 33433293
Run this on your system :

-- http://technet.microsoft.com/en-us/library/ms186740.aspx
select *
from sys.login_token;

And read the Technet link and should help as you will see this is as the site says a listing of credentials including their type (Windows, SQL Server, etc.), their principal id, sid, etc.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Job - date manual 1 47
(sql serv16)ssis 2016 question/check 1 123
sql server major issue  need help 2 79
store vs query adhoc - no show rows 4 30
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 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