April 30, 2008 at 9:37 am
Hi
I have added a couple of users with some rights. Now I want to double check if the user is
indeed limited to the rights I have assigned.
My question is
How do I impersonate a user to check if he is able to execute a sp?
On SQL Server 2005 there is 'EXECUTE AS'.
How is it done on 2000?
Thanks in advance
April 30, 2008 at 10:14 am
I believe the command is SETUSER. Look SETUSER up in SQL 200 BOL. I don't have a copy here.
Jack Corbett
Consultant - Straight Path Solutions
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
April 30, 2008 at 3:49 pm
I looked up BOL.. looks like just what I need
However it says the usage is not recommended ..
Did not mention any alternative of doing the same thing..
Thanks a lot and I will also follow the forum etiquette link
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply