SQLism

Logging and Blogging SQL Server Experiences.

Showing posts with label securables. Show all posts
Showing posts with label securables. Show all posts

Wednesday, October 8, 2014

Script to find what Permissions apply to what class of securables in SQL Server

SELECT *
FROM sys.fn_builtin_permissions(DEFAULT)
ORDER BY class_desc


Posted by SQLism at 3:06 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: apply, class, find, in, of, permissions, Script, securables, SQL Server, to, what
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2020 (6)
    • ▼  July (1)
      • Reorganize all indexes in a Database in SQL Server.
    • ►  March (1)
    • ►  February (4)
  • ►  2018 (3)
    • ►  August (3)
  • ►  2017 (10)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (4)
    • ►  January (2)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ►  2015 (10)
    • ►  September (1)
    • ►  April (9)
  • ►  2014 (53)
    • ►  October (19)
    • ►  September (33)
    • ►  June (1)
  • ►  2013 (12)
    • ►  October (2)
    • ►  September (1)
    • ►  August (5)
    • ►  July (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2012 (9)
    • ►  September (1)
    • ►  August (6)
    • ►  July (2)
Simple theme. Theme images by luoman. Powered by Blogger.