Identify user as impersonate.

Question

good morning everyone

Current_user me list the user, and if it is to impersonate, which syntax i use?

Thx

Answer 1

Your question is unclear. Are you talking about ProxyCredentails in SQL Server?

http://msdn.microsoft.com/en-us/library/ms189064(v=sql.100).aspx

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Current_user returns the name of the current user. If the user impersonates it will return the impersonated user name and not the current user name. But you can revert and make it display the current user again.

For more details , please refer this.

http://msdn.microsoft.com/en-us/library/ms176050.aspx

Refer the section C in the link mentioned above.

Thanks and Regards,

Shanoof Basheer

Answer 3

Thx for replies.

Shanoof, 

Without using the revert, syntax which brings me to the actual user, even with impersonate?

Answer 4

Hi Estevaun,

Use Original_Login()

http://msdn.microsoft.com/en-us/library/ms189492(v=sql.90).aspx

Thanks and Regards,

Shanoof Basheer

Answer 5

Thanks a lot.