Home Forums SQL Server 2008 Security (SS2K8) Deny impersonate on all logins and users. RE: Deny impersonate on all logins and users.

  • February 7, 2013 at 1:46 pm

    #1585660

    Howard i think this has an example of what you want, but i have not done this myself

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

    A. Denying IMPERSONATE permission on a login

    The following example denies IMPERSONATE permission on the SQL Server login WanidaBenshoof to a SQL Server login created from the Windows user AdvWorks\YoonM.

    USE master;

    DENY IMPERSONATE ON LOGIN::WanidaBenshoof TO [AdvWorks\YoonM];

    GO

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!