Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Warren The Case Of the Downward Pointing Arrow RE: The Case Of the Downward Pointing Arrow

  • July 2, 2014 at 5:39 am

    #1726446

    Raghavendra Mudugal (7/2/2014)

    Thank you Andy for the post, very nicely put, but for me it was like "wow I don't know anything about sql".

    I can't figure it out how to revoke and deny the connect permission to the login?

    All I know the basic step, go to that login, properties, status, there you can select "deny" for the permission to connect... - So if I consider this as "Connect permission has been denied" then what is actually a "Connect permission has been revoked"? and how to do that?

    To revoke a connect permission from user, this is to be done from the database security level like follows:

    Revoke Connect from User_Name; or to deny the user from connectong to the database:

    Deny Connect to User_Name;

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant