Solved

execution context - token

Posted on 2010-08-12
3
536 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
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 59

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Transaction logs 8 28
ODBC Driver 11 for SQL Server]Unable to open BCP host data-file 3 54
My Query is not giving correct result. Please help 5 30
TSQL previous 5 24
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now