<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Keith LaMay
»
Impersonation in an Execute As statement
17 posts, Page 2 of 2
««
1
2
Impersonation in an Execute As statement
Rate Topic
Display Mode
Topic Options
Author
Message
Simon Facer
Simon Facer
Posted Thursday, May 15, 2008 2:28 PM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 3:18 PM
Points: 1,566,
Visits: 606
(1) The 'must' gives it away, you don't have to use REVERT or another EXECUTE AS statement to change your context back.
(3) If you're an sa, you can impersonate a user with Execute As User, hence #3 is wrong - a member of the sysadmin role can use database level impersonation.
(4) "Explicitly Defined" in terms of executing as a Login or User - Execute As Login gives you impersonation at the server level, i.e. all databases, Execute As User gives you impersonation at the database only level, you can't switch to another database.
This one was pretty clear-cut ...
Post #501627
Jamie Longstreet-481950
Jamie Longstreet-481950
Posted Thursday, May 15, 2008 3:06 PM
SSCrazy
Group: General Forum Members
Last Login: Friday, June 14, 2013 8:11 AM
Points: 2,472,
Visits: 719
Thanks Simon. Makes sense now.
Jamie
Post #501657
Jack Corbett
Jack Corbett
Posted Thursday, May 15, 2008 3:48 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 10,613,
Visits: 11,952
Simon Facer (5/15/2008)
(4) "Explicitly Defined" in terms of executing as a Login or User - Execute As Login gives you impersonation at the server level, i.e. all databases, Execute As User gives you impersonation at the database only level, you can't switch to another database.
This one was pretty clear-cut ...
I guess it was clear cut if you defined scope as Server (Login) or Database(Level). The way I defined scope was how long the impersonation lasted. Similar to the scope of a variable in C# or VB, or that you had to explicitly REVERT.
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #501686
Simon Facer
Simon Facer
Posted Thursday, May 15, 2008 3:56 PM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 3:18 PM
Points: 1,566,
Visits: 606
Talking of VB or C# - I guess 'scope' is an 'overloaded' term ... different meaning depending on circumstance.
Post #501693
gurmeet.singh
gurmeet.singh
Posted Thursday, May 15, 2008 11:16 PM
Valued Member
Group: General Forum Members
Last Login: Tuesday, February 07, 2012 10:15 AM
Points: 60,
Visits: 34
I totally agree to that. For more info see
The change in execution context remains in effect until one of the following occurs:
1.Another EXECUTE AS statement is run.
2.A REVERT statement is run.
3.The session is dropped.
http://msdn.microsoft.com/en-us/library/ms181362.aspx
Post #501773
Anipaul
Anipaul
Posted Sunday, May 18, 2008 10:05 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,814,
Visits: 1,343
A good one.........
Post #502619
Wellington Aquino
Wellington Aquino
Posted Tuesday, May 27, 2008 8:22 PM
Valued Member
Group: General Forum Members
Last Login: Friday, July 30, 2010 5:17 PM
Points: 69,
Visits: 130
Happened exactly the same to me, cause I choosed 2 & 3. Simply, I'm going to check it out on the SQL Server, and I'll see what happens with the DBO/SYSADMIN issue over the EXECUTE AS command; which as far as I can see has been the hot topic here for most of us.
Post #507372
« Prev Topic
|
Next Topic »
17 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
