{"id":522,"date":"2017-08-29T10:29:20","date_gmt":"2017-08-29T15:29:20","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=522"},"modified":"2017-08-29T11:33:42","modified_gmt":"2017-08-29T16:33:42","slug":"sql-scripts-check-logins-permissions","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/sql-scripts-check-logins-permissions\/","title":{"rendered":"SQL Scripts: How To Check Logins And Permissions"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-528 size-large\" src=\"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-1024x683.jpg\" alt=\"\" width=\"800\" height=\"534\" \/><\/p>\n<p>Security and permissions are a big part of a DBA&#8217;s job, and being able to find out things such as who has elevated login permissions, or when the last time a login was used is important.<\/p>\n<p>People sometimes get SQL Server\u00a0&#8220;logins&#8221; and &#8220;users&#8221; confused, or think they are the same thing. \u00a0 A &#8220;login&#8221; allows (or denies) access to a SQL Server instance. \u00a0A &#8220;user&#8221;\u00a0allows (or denies) access to a specific database on that instance. \u00a0 Usually, a user is tied to a login, although you can have a user that is not tied to a login (known as a loginless user).<\/p>\n<p>Here are a few scripts, focused around login usage, that I use to help me answer each of the listed questions. \u00a0Since we are checking logins here, we are only looking at server access, not user permissions on individual databases. \u00a0Most of these queries are based off of <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-exec-sessions-transact-sql\" target=\"_blank\" rel=\"noopener\">sys.dm_exec_sessions<\/a>, which is a DMV that shows information about all active user connections.<\/p>\n<h4>When was the last time a login was used?<\/h4>\n<pre class=\"lang:tsql decode:true\">--list of logins and last time each logged in\r\nSELECT [Login] = login_name \r\n\t,[Last Login Time] = MAX(login_time)\r\nFROM sys.dm_exec_sessions\r\nGROUP BY [login_name];<\/pre>\n<p>&nbsp;<\/p>\n<h4>Which logins have logged in within the last X hours?<\/h4>\n<pre class=\"lang:tsql decode:true\">--all logins in the last 4 hours\r\nSELECT [Login] = login_name\r\n\t,[Last Login Time] = login_time\r\n\t,[Host] = HOST_NAME\r\n\t,[Program] = PROGRAM_NAME\r\n\t,[Client Interface] =  client_interface_name\r\n\t,[Database] = DB_NAME(database_id)\r\nFROM sys.dm_exec_sessions\r\nWHERE [login_time] &gt; DATEADD(HH,-4,getdate())--modify date as needed\r\nORDER BY [login_time] desc<\/pre>\n<p>&nbsp;<\/p>\n<h4>How many times has each login logged in within the last X hours?<\/h4>\n<pre class=\"lang:tsql decode:true\">--login counts for the last 4 hours\r\nSELECT [Login] = login_name\r\n\t,[Last Login Time] = MAX(login_time)\r\n\t,[Number Of Logins] = COUNT(*)\r\nFROM sys.dm_exec_sessions\r\nWHERE [login_time] &gt; DATEADD(HH,-4,getdate())--modify date as needed\r\nGROUP BY [login_name]\r\nORDER BY [Login] desc<\/pre>\n<p>&nbsp;<\/p>\n<h4>Which logins have Sysadmin access?<\/h4>\n<pre class=\"lang:tsql decode:true \">--check for logins with sysadmin access\r\nSELECT [Login] = name\r\n\t,[Login Type] = type_desc\r\n\t,[Disabled] = is_disabled\r\nFROM     master.sys.server_principals \r\nWHERE    IS_SRVROLEMEMBER ('sysadmin',name) = 1\r\nORDER BY [Login]<\/pre>\n<p>&nbsp;<\/p>\n<p>I should also mention that the results of these queries will only go back to the last SQL Server start time, anything that occurred before then will not be available.<\/p>\n<p><em>This post is part of an ongoing\u00a0<a href=\"https:\/\/sqlnuggets.com\/blog\/category\/sql-scripts\/\">SQL Scripts<\/a>\u00a0series, in which I list useful queries that I use in my day to day database administration.<\/em><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Security and permissions are a big part of a DBA&#8217;s job, and being able to find out things such as who has elevated login permissions, or when the last time &#8230;<\/p>\n","protected":false},"author":2,"featured_media":528,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[34,52],"tags":[35],"class_list":["post-522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-security","category-sql-scripts","tag-permissions"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Scripts: How To Check Logins And Permissions - SQL Nuggets<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Scripts: How To Check Logins And Permissions - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"Security and permissions are a big part of a DBA&#8217;s job, and being able to find out things such as who has elevated login permissions, or when the last time ...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-29T15:29:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-29T16:33:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-e1503945772529.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1253\" \/>\n\t<meta property=\"og:image:height\" content=\"835\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Eric Cobb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cfgears\" \/>\n<meta name=\"twitter:site\" content=\"@sqlnugg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Cobb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"SQL Scripts: How To Check Logins And Permissions\",\"datePublished\":\"2017-08-29T15:29:20+00:00\",\"dateModified\":\"2017-08-29T16:33:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/\"},\"wordCount\":272,\"commentCount\":2,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/security-265130_1920-e1503945772529.jpg\",\"keywords\":[\"Permissions\"],\"articleSection\":[\"Security\",\"SQL Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/\",\"name\":\"SQL Scripts: How To Check Logins And Permissions - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/security-265130_1920-e1503945772529.jpg\",\"datePublished\":\"2017-08-29T15:29:20+00:00\",\"dateModified\":\"2017-08-29T16:33:42+00:00\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/security-265130_1920-e1503945772529.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2017\\\/08\\\/security-265130_1920-e1503945772529.jpg\",\"width\":1253,\"height\":835},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/sql-scripts-check-logins-permissions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Scripts: How To Check Logins And Permissions\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"name\":\"SQL Nuggets\",\"description\":\"Nuggets Of SQL Server Knowledge\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.sqlnuggets.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\",\"name\":\"SQL Nuggets\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"width\":320,\"height\":54,\"caption\":\"SQL Nuggets\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/sqlnugg\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ericcobb\\\/\"]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\",\"name\":\"Eric Cobb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"caption\":\"Eric Cobb\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/cfgears\"],\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/author\\\/eric-cobb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Scripts: How To Check Logins And Permissions - SQL Nuggets","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/","og_locale":"en_US","og_type":"article","og_title":"SQL Scripts: How To Check Logins And Permissions - SQL Nuggets","og_description":"Security and permissions are a big part of a DBA&#8217;s job, and being able to find out things such as who has elevated login permissions, or when the last time ...","og_url":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/","og_site_name":"SQL Nuggets","article_published_time":"2017-08-29T15:29:20+00:00","article_modified_time":"2017-08-29T16:33:42+00:00","og_image":[{"width":1253,"height":835,"url":"http:\/\/www.sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-e1503945772529.jpg","type":"image\/jpeg"}],"author":"Eric Cobb","twitter_card":"summary_large_image","twitter_creator":"@cfgears","twitter_site":"@sqlnugg","twitter_misc":{"Written by":"Eric Cobb","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#article","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"SQL Scripts: How To Check Logins And Permissions","datePublished":"2017-08-29T15:29:20+00:00","dateModified":"2017-08-29T16:33:42+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/"},"wordCount":272,"commentCount":2,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-e1503945772529.jpg","keywords":["Permissions"],"articleSection":["Security","SQL Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/","url":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/","name":"SQL Scripts: How To Check Logins And Permissions - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#primaryimage"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-e1503945772529.jpg","datePublished":"2017-08-29T15:29:20+00:00","dateModified":"2017-08-29T16:33:42+00:00","breadcrumb":{"@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#primaryimage","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-e1503945772529.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-e1503945772529.jpg","width":1253,"height":835},{"@type":"BreadcrumbList","@id":"http:\/\/www.sqlnuggets.com\/sql-scripts-check-logins-permissions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"SQL Scripts: How To Check Logins And Permissions"}]},{"@type":"WebSite","@id":"http:\/\/www.sqlnuggets.com\/#website","url":"http:\/\/www.sqlnuggets.com\/","name":"SQL Nuggets","description":"Nuggets Of SQL Server Knowledge","publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.sqlnuggets.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/www.sqlnuggets.com\/#organization","name":"SQL Nuggets","url":"http:\/\/www.sqlnuggets.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","width":320,"height":54,"caption":"SQL Nuggets"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/sqlnugg","https:\/\/www.linkedin.com\/in\/ericcobb\/"]},{"@type":"Person","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a","name":"Eric Cobb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","caption":"Eric Cobb"},"sameAs":["https:\/\/x.com\/cfgears"],"url":"https:\/\/sqlnuggets.com\/author\/eric-cobb\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2017\/08\/security-265130_1920-e1503945772529.jpg","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-8q","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1255,"url":"https:\/\/sqlnuggets.com\/sql-scripts-list-databases-a-login-can-access\/","url_meta":{"origin":522,"position":0},"title":"SQL Scripts: List Databases A Login Can Access","author":"Eric Cobb","date":"January 7, 2020","format":false,"excerpt":"When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually has access to. Sure, you could look up each AD Group that user is a member of and then check\u2026","rel":"","context":"In &quot;Security&quot;","block_context":{"text":"Security","link":"https:\/\/sqlnuggets.com\/category\/security\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/12\/checklist-2470549_1280.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/12\/checklist-2470549_1280.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/12\/checklist-2470549_1280.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/12\/checklist-2470549_1280.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2019\/12\/checklist-2470549_1280.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":641,"url":"https:\/\/sqlnuggets.com\/sql-server-permissions-manager\/","url_meta":{"origin":522,"position":1},"title":"SQL Server Permissions Manager","author":"Eric Cobb","date":"November 21, 2017","format":false,"excerpt":"Last week I announced\u00a03 new open source SQL Server projects that I have on GitHub.\u00a0 One of those projects is SQL Server Permissions Manager, and today I would like to discuss it\u00a0in more detail. SQL Server Permissions Manager is a suite of scripts that allows you to take \"snapshots\" of\u2026","rel":"","context":"In &quot;Open Source Projects&quot;","block_context":{"text":"Open Source Projects","link":"https:\/\/sqlnuggets.com\/category\/open-source-projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/arrows-1577983_1280-e1511283424596.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/arrows-1577983_1280-e1511283424596.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/arrows-1577983_1280-e1511283424596.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/arrows-1577983_1280-e1511283424596.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":545,"url":"https:\/\/sqlnuggets.com\/sql-scripts-change-owner-database\/","url_meta":{"origin":522,"position":2},"title":"SQL Scripts: How To Change The Owner Of A Database","author":"Eric Cobb","date":"September 19, 2017","format":false,"excerpt":"Sometimes it becomes necessary to change the owner of a database. \u00a0When a database is first created, SQL Server likes to set the owner of that database to the login of whoever created it. \u00a0This also seems to be the case when restoring a database,\u00a0the owner is set to the\u2026","rel":"","context":"In &quot;Security&quot;","block_context":{"text":"Security","link":"https:\/\/sqlnuggets.com\/category\/security\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/09\/private-864304_1280.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/09\/private-864304_1280.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/09\/private-864304_1280.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/09\/private-864304_1280.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/09\/private-864304_1280.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":576,"url":"https:\/\/sqlnuggets.com\/3-new-open-source-sql-server-projects\/","url_meta":{"origin":522,"position":3},"title":"3 New Open Source SQL Server Projects","author":"Eric Cobb","date":"November 14, 2017","format":false,"excerpt":"Today I would like to officially unveil 3 new open source SQL Server projects that I have on GitHub!\u00a0 I will have upcoming blog posts that discuss each project in more details, but here is a brief summary of each: SQL Server Metrics Pack -\u00a0A collection of scripts for gathering\u2026","rel":"","context":"In &quot;Open Source Projects&quot;","block_context":{"text":"Open Source Projects","link":"https:\/\/sqlnuggets.com\/category\/open-source-projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/pexels-photo-211122-e1510630408305.jpeg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/pexels-photo-211122-e1510630408305.jpeg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/pexels-photo-211122-e1510630408305.jpeg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/pexels-photo-211122-e1510630408305.jpeg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":243,"url":"https:\/\/sqlnuggets.com\/stored-procedures-ignore-users-permissions\/","url_meta":{"origin":522,"position":4},"title":"Stored Procedures Ignore User&#8217;s Permissions","author":"Eric Cobb","date":"July 13, 2016","format":false,"excerpt":"So, that title may be a little misleading to some. It is not meant as a blanket statement about all procedures and all permissions, but rather a specific situation that I encountered recently. I ran into a case where a user was able access data in a table, even though\u2026","rel":"","context":"In &quot;Security&quot;","block_context":{"text":"Security","link":"https:\/\/sqlnuggets.com\/category\/security\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":949,"url":"https:\/\/sqlnuggets.com\/sql-server-permissions-manager-updates-january-2019\/","url_meta":{"origin":522,"position":5},"title":"SQL Server Permissions Manager Updates &#8211; January 2019","author":"Eric Cobb","date":"January 31, 2019","format":false,"excerpt":"I recently made some updates to my SQL Server Permissions Manager project on GitHub. These updates mainly consisted of bug fixes and documentation updates, although I did also add the ability to snapshot server level permissions such as \"sysadmin\" or \"securityadmin\". Here is the (small) list of changes: Fixed bug\u2026","rel":"","context":"In &quot;Open Source Projects&quot;","block_context":{"text":"Open Source Projects","link":"https:\/\/sqlnuggets.com\/category\/open-source-projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/organization-chart-2556925_1280.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/organization-chart-2556925_1280.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/organization-chart-2556925_1280.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/organization-chart-2556925_1280.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/11\/organization-chart-2556925_1280.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/comments?post=522"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/522\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media\/528"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}