Friday, February 24, 2012

In Yukon, can EXECUTE AS be disabled?

For SQL Server 2005, can EXECUTE AS be disabled? If so, how?
Thanks,
Larry ChesnutFrom SQL Server 2005 BOL:
Server or database principals other than sa or dbo can call EXECUTE AS.
The user calling the EXECUTE AS statement must have IMPERSONATE permissions
on the target principal
If it is not granted, it can be executed as.
http://communities.microsoft.com/ne...lcid=us

--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Chesnut" <Larry@.scalabilityexpertsonline.com> wrote in message
news:%23iRHOw2lFHA.2080@.TK2MSFTNGP14.phx.gbl...
> For SQL Server 2005, can EXECUTE AS be disabled? If so, how?
>
> Thanks,
> Larry Chesnut
>

No comments:

Post a Comment