Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

What is impersonation in SQL Server and task is One of User ID should impersonate to other ID,

Hi All,
What is impersonation in SQL Server?
I have a task
One of User ID should impersonate to other ID.
how to do that?

Thanks!


0
msdba
Asked:
msdba
3 Solutions
 
SQLSergentMikeCommented:
Set up a credential and a proxy account.
0
 
radcaesarCommented:
executing a query/sp as another user using "Execute AS" keyword.

There is no specific setup for this.

http://msdn.microsoft.com/en-us/library/ms188304%28v=SQL.90%29.aspx
0
 
SQLSergentMikeCommented:
Proxy account:-)
0
 
msdbaAuthor Commented:
Thanks!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now