Tag Archives: security

  1. Dealing with multiple AD accounts

    7

    November 19, 2018 by Kenneth Fisher

    To help promote the seperation of duties one of the things my company has done is to divide our permissions …
    Continue reading

  2. How do I grant permissions to view users and their permissions?

    1

    September 17, 2018 by Kenneth Fisher

    tl;dr; VIEW DEFINITION Every now and again you’ll have a user that needs to be able to see what permissions …
    Continue reading

  3. What are my permissions?

    1

    August 16, 2018 by Kenneth Fisher

    Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
    Continue reading

  4. Balancing Security Concerns.

    2

    July 12, 2018 by Kenneth Fisher

    I have a presentation I do every now again on security basics that I’m actually quite proud of. One of …
    Continue reading

  5. Be our guest, be our guest, put our database to the test.

    3

    June 25, 2018 by Kenneth Fisher

    When I think of the public role I often think of the guest database principal (user) at the same time. …
    Continue reading

  6. The public role

    2

    May 23, 2018 by Kenneth Fisher

    A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t. …
    Continue reading

  7. Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101

    1

    April 10, 2018 by Kenneth Fisher

    Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
    Continue reading

  8. Double hop error when using SQLCMD

    2

    February 26, 2018 by Kenneth Fisher

    tl;dr; SQLCMD v2014 and up has special requirements for Kerberos. One of the problems with linked servers (no rude noises …
    Continue reading

  9. SQL Homework – February 2018 – Work with security

    Leave a comment

    February 5, 2018 by Kenneth Fisher

    This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
    Continue reading

  10. What’s dbo?

    3

    January 22, 2018 by Kenneth Fisher

    Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,470 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013