Where do I go to find out who has rights to impersonate other logins
under SQL 2005? Where is this information held, please. Not having
much luck Googling this.

I assume you mean who can run EXECUTE AS. Here's what is documented:

To specify EXECUTE AS on a login, the caller must have IMPERSONATE
permissions on the specified login name. To specify EXECUTE AS on a database
user, the caller must have IMPERSONATE permissions on the specified user
name. When EXECUTE AS CALLER is specified, IMPERSONATE permissions are not
required.

But impersoantion can mean different things, so this may not be what you
were asking. If not, please clarify.

Linchi

"nzrdb6" wrote: