Tag Archives: database permissions

  1. The CONNECT permission

    2

    January 27, 2016 by Kenneth Fisher

    The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at …
    Continue reading

  2. Administrative Logins and Users

    Leave a comment

    November 2, 2015 by Kenneth Fisher

    If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this: Please …
    Continue reading

  3. Zombie AD Groups

    4

    September 21, 2015 by Kenneth Fisher

    I spent something like 2 hours today trying to figure out how a particular user had access to one of …
    Continue reading

  4. Permissions Posters

    3

    July 27, 2015 by Kenneth Fisher

    I’ve been doing a lot of research recently for my permissions session and for a project at work. During said …
    Continue reading

  5. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

  6. TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

    7

    February 10, 2015 by Kenneth Fisher

    So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it …
    Continue reading

  7. Discussing Security with Boris Hristov on SQLHangout #29

    Leave a comment

    January 12, 2015 by Kenneth Fisher

    Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I …
    Continue reading

  8. TSQL Tuesday #60: Something New Learned – What permissions does <username> have?

    5

    November 11, 2014 by Kenneth Fisher

    What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
    Continue reading

  9. Deny vs Revoke

    1

    August 4, 2014 by Kenneth Fisher

    Quick quiz. Which of these two commands is the opposite of GRANT? DENY REVOKE   Well lets start with some …
    Continue reading

  10. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 847 other followers