SQLQuickfixes

Nothing loose by learning again. Definitely gain If you just don't let it go away. - Bvsc.

Pages

  • Home
  • SQL2012 - Denali
  • SQL Server 2014 - SQL14

Monday, April 8, 2013

System View Permissions

Select permissions on system views for regular user
GRANT VIEW SERVER STATE TO LoginName

Deny permissions on system views for regular user
DENY VIEW SERVER STATE TO LoginName

Posted by PraveenSynick at 7:05 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2022 (1)
    • ►  March (1)
  • ►  2021 (1)
    • ►  December (1)
  • ►  2020 (2)
    • ►  February (2)
  • ►  2018 (1)
    • ►  August (1)
  • ►  2017 (2)
    • ►  March (1)
    • ►  January (1)
  • ►  2015 (12)
    • ►  June (1)
    • ►  May (1)
    • ►  April (5)
    • ►  March (2)
    • ►  February (1)
    • ►  January (2)
  • ►  2014 (10)
    • ►  December (4)
    • ►  November (2)
    • ►  October (1)
    • ►  May (1)
    • ►  April (1)
    • ►  February (1)
  • ▼  2013 (12)
    • ►  December (1)
    • ►  November (5)
    • ▼  April (5)
      • Dropping list of table at a time
      • Get all tables information in the database
      • Get DB roles
      • SSIS Package Error while exporting data to EXCEL
      • System View Permissions
    • ►  January (1)
  • ►  2012 (14)
    • ►  December (3)
    • ►  November (5)
    • ►  October (6)

About Me

PraveenSynick
View my complete profile
Watermark theme. Powered by Blogger.