text: 
  
  
  
  
  
  <!DOCTYPE html>
  <html lang="en">
    <head>
      <meta charset="utf-8">
    <link rel="dns-prefetch" href="https://github.githubassets.com">
    <link rel="dns-prefetch" href="https://avatars0.githubusercontent.com">
    <link rel="dns-prefetch" href="https://avatars1.githubusercontent.com">
    <link rel="dns-prefetch" href="https://avatars2.githubusercontent.com">
    <link rel="dns-prefetch" href="https://avatars3.githubusercontent.com">
    <link rel="dns-prefetch" href="https://github-cloud.s3.amazonaws.com">
    <link rel="dns-prefetch" href="https://user-images.githubusercontent.com/">
  
  
  
    <link crossorigin="anonymous" media="all" integrity="sha512-8B5lvNq1b88YJg2eQ7wXcWwl490xeelSavDDj7NEOtpEK7m0tKkmFi9BDX+S+nYyh/teAumil+CjK/AscuQrdg==" rel="stylesheet" href="https://github.githubassets.com/assets/frameworks-081940cf9af751b35bb9fd062060601a.css" />
    
      <link crossorigin="anonymous" media="all" integrity="sha512-KOqqPXmPgXnSCDE/RVobSMDp3N81KrS5yqxFG9e6gN2YdLVtBZtRXT/0f3YHTGU2PwyqLmcBdz6bARkVDb4Nhg==" rel="stylesheet" href="https://github.githubassets.com/assets/github-f596d1693f63c9206f4e5d91b1c00078.css" />
      
      
      
      
  
    <meta name="viewport" content="width=device-width">
    
    <title>Public-Presentations/security Script databases.sql at master · williamadba/Public-Presentations</title>
      <meta name="description" content="PowerPoint, labs, downloadables. Contribute to williamadba/Public-Presentations development by creating an account on GitHub.">
      <link rel="search" type="application/opensearchdescription+xml" href="/opensearch.xml" title="GitHub">
    <link rel="fluid-icon" href="https://github.com/fluidicon.png" title="GitHub">
    <meta property="fb:app_id" content="1401488693436528">
  
      <meta name="twitter:image:src" content="https://avatars1.githubusercontent.com/u/6641470?s=400&amp;v=4" /><meta name="twitter:site" content="@github" /><meta name="twitter:card" content="summary" /><meta name="twitter:title" content="williamadba/Public-Presentations" /><meta name="twitter:description" content="PowerPoint, labs, downloadables. Contribute to williamadba/Public-Presentations development by creating an account on GitHub." />
      <meta property="og:image" content="https://avatars1.githubusercontent.com/u/6641470?s=400&amp;v=4" /><meta property="og:site_name" content="GitHub" /><meta property="og:type" content="object" /><meta property="og:title" content="williamadba/Public-Presentations" /><meta property="og:url" content="https://github.com/williamadba/Public-Presentations" /><meta property="og:description" content="PowerPoint, labs, downloadables. Contribute to williamadba/Public-Presentations development by creating an account on GitHub." />
  
    <link rel="assets" href="https://github.githubassets.com/">
    <link rel="web-socket" href="wss://live.github.com/_sockets/VjI6NDI5NzI3NTY1OmE1Nzc2YWExMGVmMDZjZTc4MzMyOGIzNWI4Y2VhMzk4YjM3MThhNDZjNTkxOGQ5M2RmNGIyMTE3NzlmNDJiMmE=--53a7256d3d33fc7649944129aeb3e66c1eb280b0">
    <meta name="pjax-timeout" content="1000">
    <link rel="sudo-modal" href="/sessions/sudo_modal">
    <meta name="request-id" content="C94B:568D:164C67B:22D7E2E:5D3ECC9C" data-pjax-transient>
  
  
    
  
    <meta name="selected-link" value="repo_source" data-pjax-transient>
  
        <meta name="google-site-verification" content="KT5gs8h0wvaagLKAVWq8bbeNwnZZK1r1XQysX3xurLU">
      <meta name="google-site-verification" content="ZzhVyEFwb7w3e0-uOTltm8Jsck2F5StVihD0exw2fsA">
      <meta name="google-site-verification" content="GXs5KoUUkNCoaAZn7wPN-t01Pywp9M3sEjnt_3_ZWPc">
  
    <meta name="octolytics-host" content="collector.githubapp.com" /><meta name="octolytics-app-id" content="github" /><meta name="octolytics-event-url" content="https://collector.githubapp.com/github-external/browser_event" /><meta name="octolytics-dimension-request_id" content="C94B:568D:164C67B:22D7E2E:5D3ECC9C" /><meta name="octolytics-dimension-region_edge" content="ams" /><meta name="octolytics-dimension-region_render" content="iad" /><meta name="octolytics-actor-id" content="31067101" /><meta name="octolytics-actor-login" content="nmbazima" /><meta name="octolytics-actor-hash" content="dc63dc41cf425b13a26843c2547de64290be7380e4e2038bc2636572397b17d7" />
  <meta name="analytics-location" content="/&lt;user-name&gt;/&lt;repo-name&gt;/blob/show" data-pjax-transient="true" />
  
  
  
      <meta name="google-analytics" content="UA-3769691-2">
  
    <meta class="js-ga-set" name="userId" content="06db85e785723595827291365512a4a3">
  
  <meta class="js-ga-set" name="dimension1" content="Logged In">
  
  
  
    
  
        <meta name="hostname" content="github.com">
      <meta name="user-login" content="nmbazima">
  
        <meta name="expected-hostname" content="github.com">
      <meta name="js-proxy-site-detection-payload" content="YzY4N2VhMTdjNzgwNjI4M2EyOGYzNjYxYTUyNjNiYzUzMWRjYjI0ODcyYWU2ZWRiYjJkNzY2MDUyMjQwZWViOHx7InJlbW90ZV9hZGRyZXNzIjoiNDEuMjIzLjExNy42NyIsInJlcXVlc3RfaWQiOiJDOTRCOjU2OEQ6MTY0QzY3QjoyMkQ3RTJFOjVEM0VDQzlDIiwidGltZXN0YW1wIjoxNTY0Mzk2NzA2LCJob3N0IjoiZ2l0aHViLmNvbSJ9">
  
      <meta name="enabled-features" content="MARKETPLACE_FEATURED_BLOG_POSTS,MARKETPLACE_INVOICED_BILLING,MARKETPLACE_SOCIAL_PROOF_CUSTOMERS,MARKETPLACE_TRENDING_SOCIAL_PROOF,MARKETPLACE_RECOMMENDATIONS,MARKETPLACE_PENDING_INSTALLATIONS,NOTIFY_ON_BLOCK,RELATED_ISSUES">
  
    <meta name="html-safe-nonce" content="3999c8ef9e73dedca78cffc9915f2b44384de341">
  
    <meta http-equiv="x-pjax-version" content="3c1643205f794dc4e59e8a316923fc4f">
    
  
        <link href="https://github.com/williamadba/Public-Presentations/commits/master.atom" rel="alternate" title="Recent Commits to Public-Presentations:master" type="application/atom+xml">
  
    <meta name="go-import" content="github.com/williamadba/Public-Presentations git https://github.com/williamadba/Public-Presentations.git">
  
    <meta name="octolytics-dimension-user_id" content="6641470" /><meta name="octolytics-dimension-user_login" content="williamadba" /><meta name="octolytics-dimension-repository_id" content="122529269" /><meta name="octolytics-dimension-repository_nwo" content="williamadba/Public-Presentations" /><meta name="octolytics-dimension-repository_public" content="true" /><meta name="octolytics-dimension-repository_is_fork" content="false" /><meta name="octolytics-dimension-repository_network_root_id" content="122529269" /><meta name="octolytics-dimension-repository_network_root_nwo" content="williamadba/Public-Presentations" /><meta name="octolytics-dimension-repository_explore_github_marketplace_ci_cta_shown" content="false" />
  
  
      <link rel="canonical" href="https://github.com/williamadba/Public-Presentations/blob/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql" data-pjax-transient>
  
  
    <meta name="browser-stats-url" content="https://api.github.com/_private/browser/stats">
  
    <meta name="browser-errors-url" content="https://api.github.com/_private/browser/errors">
  
    <link rel="mask-icon" href="https://github.githubassets.com/pinned-octocat.svg" color="#000000">
    <link rel="icon" type="image/x-icon" class="js-site-favicon" href="https://github.githubassets.com/favicon.ico">
  
  <meta name="theme-color" content="#1e2327">
  
  
    <meta name="u2f-enabled" content="true">
  
  
  
    <link rel="manifest" href="/manifest.json" crossOrigin="use-credentials">
  
    </head>
  
    <body class="logged-in env-production page-responsive page-blob">
      
  
    <div class="position-relative js-header-wrapper ">
      <a href="#start-of-content" tabindex="1" class="p-3 bg-blue text-white show-on-focus js-skip-to-content">Skip to content</a>
      <div id="js-pjax-loader-bar" class="pjax-loader-bar"><div class="progress"></div></div>
  
      
      
      
  
  
            <header class="Header js-details-container Details flex-wrap flex-lg-nowrap p-responsive" role="banner">
  
      <div class="Header-item d-none d-lg-flex">
        <a class="Header-link" href="https://github.com/" data-hotkey="g d" aria-label="Homepage" data-ga-click="Header, go to dashboard, icon:logo">
    <svg class="octicon octicon-mark-github v-align-middle" height="32" viewBox="0 0 16 16" version="1.1" width="32" aria-hidden="true"><path fill-rule="evenodd" d="M8 0C3.58 0 0 3.58 0 8c0 3.54 2.29 6.53 5.47 7.59.4.07.55-.17.55-.38 0-.19-.01-.82-.01-1.49-2.01.37-2.53-.49-2.69-.94-.09-.23-.48-.94-.82-1.13-.28-.15-.68-.52-.01-.53.63-.01 1.08.58 1.23.82.72 1.21 1.87.87 2.33.66.07-.52.28-.87.51-1.07-1.78-.2-3.64-.89-3.64-3.95 0-.87.31-1.59.82-2.15-.08-.2-.36-1.02.08-2.12 0 0 .67-.21 2.2.82.64-.18 1.32-.27 2-.27.68 0 1.36.09 2 .27 1.53-1.04 2.2-.82 2.2-.82.44 1.1.16 1.92.08 2.12.51.56.82 1.27.82 2.15 0 3.07-1.87 3.75-3.65 3.95.29.25.54.73.54 1.48 0 1.07-.01 1.93-.01 2.2 0 .21.15.46.55.38A8.013 8.013 0 0 0 16 8c0-4.42-3.58-8-8-8z"/></svg>
  </a>
  
      </div>
  
      <div class="Header-item d-lg-none">
        <button class="Header-link btn-link js-details-target" type="button" aria-label="Toggle navigation" aria-expanded="false">
          <svg height="24" class="octicon octicon-three-bars" viewBox="0 0 12 16" version="1.1" width="18" aria-hidden="true"><path fill-rule="evenodd" d="M11.41 9H.59C0 9 0 8.59 0 8c0-.59 0-1 .59-1H11.4c.59 0 .59.41.59 1 0 .59 0 1-.59 1h.01zm0-4H.59C0 5 0 4.59 0 4c0-.59 0-1 .59-1H11.4c.59 0 .59.41.59 1 0 .59 0 1-.59 1h.01zM.59 11H11.4c.59 0 .59.41.59 1 0 .59 0 1-.59 1H.59C0 13 0 12.59 0 12c0-.59 0-1 .59-1z"/></svg>
        </button>
      </div>
  
      <div class="Header-item Header-item--full flex-column flex-lg-row width-full flex-order-2 flex-lg-order-none mr-0 mr-lg-3 mt-3 mt-lg-0 Details-content--hidden">
          <div class="header-search flex-self-stretch flex-lg-self-auto mr-0 mr-lg-3 mb-3 mb-lg-0 scoped-search site-scoped-search js-site-search position-relative js-jump-to"
    role="combobox"
    aria-owns="jump-to-results"
    aria-label="Search or jump to"
    aria-haspopup="listbox"
    aria-expanded="false"
  >
    <div class="position-relative">
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="js-site-search-form" role="search" aria-label="Site" data-scope-type="Repository" data-scope-id="122529269" data-scoped-search-url="/williamadba/Public-Presentations/search" data-unscoped-search-url="/search" action="/williamadba/Public-Presentations/search" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="&#x2713;" />
        <label class="form-control input-sm header-search-wrapper p-0 header-search-wrapper-jump-to position-relative d-flex flex-justify-between flex-items-center js-chromeless-input-container">
          <input type="text"
            class="form-control input-sm header-search-input jump-to-field js-jump-to-field js-site-search-focus js-site-search-field is-clearable"
            data-hotkey="s,/"
            name="q"
            value=""
            placeholder="Search or jump to…"
            data-unscoped-placeholder="Search or jump to…"
            data-scoped-placeholder="Search or jump to…"
            autocapitalize="off"
            aria-autocomplete="list"
            aria-controls="jump-to-results"
            aria-label="Search or jump to…"
            data-jump-to-suggestions-path="/_graphql/GetSuggestedNavigationDestinations#csrf-token=MO0hw7ryJi3cPPIVy82KyY/a/j89A+4X4HH5R6SFhKmbImWefeDsxTuoR84tZnrGkw5BeCiHhxEg48LUvXRrwA=="
            spellcheck="false"
            autocomplete="off"
            >
            <input type="hidden" class="js-site-search-type-field" name="type" >
              <img src="https://github.githubassets.com/images/search-key-slash.svg" alt="" class="mr-2 header-search-key-slash">
  
              <div class="Box position-absolute overflow-hidden d-none jump-to-suggestions js-jump-to-suggestions-container">
                
  <ul class="d-none js-jump-to-suggestions-template-container">
    
  
  <li class="d-flex flex-justify-start flex-items-center p-0 f5 navigation-item js-navigation-item js-jump-to-suggestion" role="option">
    <a tabindex="-1" class="no-underline d-flex flex-auto flex-items-center jump-to-suggestions-path js-jump-to-suggestion-path js-navigation-open p-2" href="">
      <div class="jump-to-octicon js-jump-to-octicon flex-shrink-0 mr-2 text-center d-none">
        <svg height="16" width="16" class="octicon octicon-repo flex-shrink-0 js-jump-to-octicon-repo d-none" title="Repository" aria-label="Repository" viewBox="0 0 12 16" version="1.1" role="img"><path fill-rule="evenodd" d="M4 9H3V8h1v1zm0-3H3v1h1V6zm0-2H3v1h1V4zm0-2H3v1h1V2zm8-1v12c0 .55-.45 1-1 1H6v2l-1.5-1.5L3 16v-2H1c-.55 0-1-.45-1-1V1c0-.55.45-1 1-1h10c.55 0 1 .45 1 1zm-1 10H1v2h2v-1h3v1h5v-2zm0-10H2v9h9V1z"/></svg>
        <svg height="16" width="16" class="octicon octicon-project flex-shrink-0 js-jump-to-octicon-project d-none" title="Project" aria-label="Project" viewBox="0 0 15 16" version="1.1" role="img"><path fill-rule="evenodd" d="M10 12h3V2h-3v10zm-4-2h3V2H6v8zm-4 4h3V2H2v12zm-1 1h13V1H1v14zM14 0H1a1 1 0 0 0-1 1v14a1 1 0 0 0 1 1h13a1 1 0 0 0 1-1V1a1 1 0 0 0-1-1z"/></svg>
        <svg height="16" width="16" class="octicon octicon-search flex-shrink-0 js-jump-to-octicon-search d-none" title="Search" aria-label="Search" viewBox="0 0 16 16" version="1.1" role="img"><path fill-rule="evenodd" d="M15.7 13.3l-3.81-3.83A5.93 5.93 0 0 0 13 6c0-3.31-2.69-6-6-6S1 2.69 1 6s2.69 6 6 6c1.3 0 2.48-.41 3.47-1.11l3.83 3.81c.19.2.45.3.7.3.25 0 .52-.09.7-.3a.996.996 0 0 0 0-1.41v.01zM7 10.7c-2.59 0-4.7-2.11-4.7-4.7 0-2.59 2.11-4.7 4.7-4.7 2.59 0 4.7 2.11 4.7 4.7 0 2.59-2.11 4.7-4.7 4.7z"/></svg>
      </div>
  
      <img class="avatar mr-2 flex-shrink-0 js-jump-to-suggestion-avatar d-none" alt="" aria-label="Team" src="" width="28" height="28">
  
      <div class="jump-to-suggestion-name js-jump-to-suggestion-name flex-auto overflow-hidden text-left no-wrap css-truncate css-truncate-target">
      </div>
  
      <div class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search">
        <span class="js-jump-to-badge-search-text-default d-none" aria-label="in this repository">
          In this repository
        </span>
        <span class="js-jump-to-badge-search-text-global d-none" aria-label="in all of GitHub">
          All GitHub
        </span>
        <span aria-hidden="true" class="d-inline-block ml-1 v-align-middle">↵</span>
      </div>
  
      <div aria-hidden="true" class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none d-on-nav-focus js-jump-to-badge-jump">
        Jump to
        <span class="d-inline-block ml-1 v-align-middle">↵</span>
      </div>
    </a>
  </li>
  
  </ul>
  
  <ul class="d-none js-jump-to-no-results-template-container">
    <li class="d-flex flex-justify-center flex-items-center f5 d-none js-jump-to-suggestion p-2">
      <span class="text-gray">No suggested jump to results</span>
    </li>
  </ul>
  
  <ul id="jump-to-results" role="listbox" class="p-0 m-0 js-navigation-container jump-to-suggestions-results-container js-jump-to-suggestions-results-container">
    
  
  <li class="d-flex flex-justify-start flex-items-center p-0 f5 navigation-item js-navigation-item js-jump-to-scoped-search d-none" role="option">
    <a tabindex="-1" class="no-underline d-flex flex-auto flex-items-center jump-to-suggestions-path js-jump-to-suggestion-path js-navigation-open p-2" href="">
      <div class="jump-to-octicon js-jump-to-octicon flex-shrink-0 mr-2 text-center d-none">
        <svg height="16" width="16" class="octicon octicon-repo flex-shrink-0 js-jump-to-octicon-repo d-none" title="Repository" aria-label="Repository" viewBox="0 0 12 16" version="1.1" role="img"><path fill-rule="evenodd" d="M4 9H3V8h1v1zm0-3H3v1h1V6zm0-2H3v1h1V4zm0-2H3v1h1V2zm8-1v12c0 .55-.45 1-1 1H6v2l-1.5-1.5L3 16v-2H1c-.55 0-1-.45-1-1V1c0-.55.45-1 1-1h10c.55 0 1 .45 1 1zm-1 10H1v2h2v-1h3v1h5v-2zm0-10H2v9h9V1z"/></svg>
        <svg height="16" width="16" class="octicon octicon-project flex-shrink-0 js-jump-to-octicon-project d-none" title="Project" aria-label="Project" viewBox="0 0 15 16" version="1.1" role="img"><path fill-rule="evenodd" d="M10 12h3V2h-3v10zm-4-2h3V2H6v8zm-4 4h3V2H2v12zm-1 1h13V1H1v14zM14 0H1a1 1 0 0 0-1 1v14a1 1 0 0 0 1 1h13a1 1 0 0 0 1-1V1a1 1 0 0 0-1-1z"/></svg>
        <svg height="16" width="16" class="octicon octicon-search flex-shrink-0 js-jump-to-octicon-search d-none" title="Search" aria-label="Search" viewBox="0 0 16 16" version="1.1" role="img"><path fill-rule="evenodd" d="M15.7 13.3l-3.81-3.83A5.93 5.93 0 0 0 13 6c0-3.31-2.69-6-6-6S1 2.69 1 6s2.69 6 6 6c1.3 0 2.48-.41 3.47-1.11l3.83 3.81c.19.2.45.3.7.3.25 0 .52-.09.7-.3a.996.996 0 0 0 0-1.41v.01zM7 10.7c-2.59 0-4.7-2.11-4.7-4.7 0-2.59 2.11-4.7 4.7-4.7 2.59 0 4.7 2.11 4.7 4.7 0 2.59-2.11 4.7-4.7 4.7z"/></svg>
      </div>
  
      <img class="avatar mr-2 flex-shrink-0 js-jump-to-suggestion-avatar d-none" alt="" aria-label="Team" src="" width="28" height="28">
  
      <div class="jump-to-suggestion-name js-jump-to-suggestion-name flex-auto overflow-hidden text-left no-wrap css-truncate css-truncate-target">
      </div>
  
      <div class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search">
        <span class="js-jump-to-badge-search-text-default d-none" aria-label="in this repository">
          In this repository
        </span>
        <span class="js-jump-to-badge-search-text-global d-none" aria-label="in all of GitHub">
          All GitHub
        </span>
        <span aria-hidden="true" class="d-inline-block ml-1 v-align-middle">↵</span>
      </div>
  
      <div aria-hidden="true" class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none d-on-nav-focus js-jump-to-badge-jump">
        Jump to
        <span class="d-inline-block ml-1 v-align-middle">↵</span>
      </div>
    </a>
  </li>
  
    
  
  <li class="d-flex flex-justify-start flex-items-center p-0 f5 navigation-item js-navigation-item js-jump-to-global-search d-none" role="option">
    <a tabindex="-1" class="no-underline d-flex flex-auto flex-items-center jump-to-suggestions-path js-jump-to-suggestion-path js-navigation-open p-2" href="">
      <div class="jump-to-octicon js-jump-to-octicon flex-shrink-0 mr-2 text-center d-none">
        <svg height="16" width="16" class="octicon octicon-repo flex-shrink-0 js-jump-to-octicon-repo d-none" title="Repository" aria-label="Repository" viewBox="0 0 12 16" version="1.1" role="img"><path fill-rule="evenodd" d="M4 9H3V8h1v1zm0-3H3v1h1V6zm0-2H3v1h1V4zm0-2H3v1h1V2zm8-1v12c0 .55-.45 1-1 1H6v2l-1.5-1.5L3 16v-2H1c-.55 0-1-.45-1-1V1c0-.55.45-1 1-1h10c.55 0 1 .45 1 1zm-1 10H1v2h2v-1h3v1h5v-2zm0-10H2v9h9V1z"/></svg>
        <svg height="16" width="16" class="octicon octicon-project flex-shrink-0 js-jump-to-octicon-project d-none" title="Project" aria-label="Project" viewBox="0 0 15 16" version="1.1" role="img"><path fill-rule="evenodd" d="M10 12h3V2h-3v10zm-4-2h3V2H6v8zm-4 4h3V2H2v12zm-1 1h13V1H1v14zM14 0H1a1 1 0 0 0-1 1v14a1 1 0 0 0 1 1h13a1 1 0 0 0 1-1V1a1 1 0 0 0-1-1z"/></svg>
        <svg height="16" width="16" class="octicon octicon-search flex-shrink-0 js-jump-to-octicon-search d-none" title="Search" aria-label="Search" viewBox="0 0 16 16" version="1.1" role="img"><path fill-rule="evenodd" d="M15.7 13.3l-3.81-3.83A5.93 5.93 0 0 0 13 6c0-3.31-2.69-6-6-6S1 2.69 1 6s2.69 6 6 6c1.3 0 2.48-.41 3.47-1.11l3.83 3.81c.19.2.45.3.7.3.25 0 .52-.09.7-.3a.996.996 0 0 0 0-1.41v.01zM7 10.7c-2.59 0-4.7-2.11-4.7-4.7 0-2.59 2.11-4.7 4.7-4.7 2.59 0 4.7 2.11 4.7 4.7 0 2.59-2.11 4.7-4.7 4.7z"/></svg>
      </div>
  
      <img class="avatar mr-2 flex-shrink-0 js-jump-to-suggestion-avatar d-none" alt="" aria-label="Team" src="" width="28" height="28">
  
      <div class="jump-to-suggestion-name js-jump-to-suggestion-name flex-auto overflow-hidden text-left no-wrap css-truncate css-truncate-target">
      </div>
  
      <div class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search">
        <span class="js-jump-to-badge-search-text-default d-none" aria-label="in this repository">
          In this repository
        </span>
        <span class="js-jump-to-badge-search-text-global d-none" aria-label="in all of GitHub">
          All GitHub
        </span>
        <span aria-hidden="true" class="d-inline-block ml-1 v-align-middle">↵</span>
      </div>
  
      <div aria-hidden="true" class="border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none d-on-nav-focus js-jump-to-badge-jump">
        Jump to
        <span class="d-inline-block ml-1 v-align-middle">↵</span>
      </div>
    </a>
  </li>
  
  
      <li class="d-flex flex-justify-center flex-items-center p-0 f5 js-jump-to-suggestion">
        <img src="https://github.githubassets.com/images/spinners/octocat-spinner-128.gif" alt="Octocat Spinner Icon" class="m-2" width="28">
      </li>
  </ul>
  
              </div>
        </label>
  </form>  </div>
  </div>
  
  
        <nav class="d-flex flex-column flex-lg-row flex-self-stretch flex-lg-self-auto" aria-label="Global">
      <a class="Header-link d-block d-lg-none py-2 py-lg-0 border-top border-lg-top-0 border-white-fade-15" data-ga-click="Header, click, Nav menu - item:dashboard:user" aria-label="Dashboard" href="/dashboard">
        Dashboard
  </a>
    <a class="js-selected-navigation-item Header-link  mr-0 mr-lg-3 py-2 py-lg-0 border-top border-lg-top-0 border-white-fade-15" data-hotkey="g p" data-ga-click="Header, click, Nav menu - item:pulls context:user" aria-label="Pull requests you created" data-selected-links="/pulls /pulls/assigned /pulls/mentioned /pulls" href="/pulls">
      Pull requests
  </a>
    <a class="js-selected-navigation-item Header-link  mr-0 mr-lg-3 py-2 py-lg-0 border-top border-lg-top-0 border-white-fade-15" data-hotkey="g i" data-ga-click="Header, click, Nav menu - item:issues context:user" aria-label="Issues you created" data-selected-links="/issues /issues/assigned /issues/mentioned /issues" href="/issues">
      Issues
  </a>
      <div class="mr-0 mr-lg-3 py-2 py-lg-0 border-top border-lg-top-0 border-white-fade-15">
        <a class="js-selected-navigation-item Header-link" data-ga-click="Header, click, Nav menu - item:marketplace context:user" data-octo-click="marketplace_click" data-octo-dimensions="location:nav_bar" data-selected-links=" /marketplace" href="/marketplace">
          Marketplace
  </a>      
      </div>
  
    <a class="js-selected-navigation-item Header-link  mr-0 mr-lg-3 py-2 py-lg-0 border-top border-lg-top-0 border-white-fade-15" data-ga-click="Header, click, Nav menu - item:explore" data-selected-links="/explore /trending /trending/developers /integrations /integrations/feature/code /integrations/feature/collaborate /integrations/feature/ship showcases showcases_search showcases_landing /explore" href="/explore">
      Explore
  </a>
  
  
      <a class="Header-link d-block d-lg-none mr-0 mr-lg-3 py-2 py-lg-0 border-top border-lg-top-0 border-white-fade-15" href="https://github.com/nmbazima">
        <img class="avatar" height="20" width="20" alt="@nmbazima" src="https://avatars0.githubusercontent.com/u/31067101?s=60&amp;v=4" />
        nmbazima
  </a>
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form action="/logout" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="j15Tok9lrjsZQWjh7HAvn3GY82jGeSY9dGYm73AYOpLNWA5fV5SOZyY/Qu2/+OEEjiQyphLYJXyDn8f1FuT4yg==" />
        <button type="submit" class="Header-link mr-0 mr-lg-3 py-2 py-lg-0 border-top border-lg-top-0 border-white-fade-15 d-lg-none btn-link d-block width-full text-left" data-ga-click="Header, sign out, icon:logout" style="padding-left: 2px;">
          <svg class="octicon octicon-sign-out v-align-middle" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 9V7H8V5h4V3l4 3-4 3zm-2 3H6V3L2 1h8v3h1V1c0-.55-.45-1-1-1H1C.45 0 0 .45 0 1v11.38c0 .39.22.73.55.91L6 16.01V13h4c.55 0 1-.45 1-1V8h-1v4z"/></svg>
          Sign out
        </button>
  </form></nav>
  
      </div>
  
      <div class="Header-item Header-item--full flex-justify-center d-lg-none position-relative">
        <div class="css-truncate css-truncate-target width-fit position-absolute left-0 right-0 text-center">
                <svg class="octicon octicon-repo" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9H3V8h1v1zm0-3H3v1h1V6zm0-2H3v1h1V4zm0-2H3v1h1V2zm8-1v12c0 .55-.45 1-1 1H6v2l-1.5-1.5L3 16v-2H1c-.55 0-1-.45-1-1V1c0-.55.45-1 1-1h10c.55 0 1 .45 1 1zm-1 10H1v2h2v-1h3v1h5v-2zm0-10H2v9h9V1z"/></svg>
      <a class="Header-link" href="/williamadba">williamadba</a>
      /
      <a class="Header-link" href="/williamadba/Public-Presentations">Public-Presentations</a>
  
  </div>
      </div>
  
      <div class="Header-item position-relative d-none d-lg-flex">
        
  
      </div>
  
      <div class="Header-item mr-0 mr-lg-3 flex-order-1 flex-lg-order-none">
        
  
      <a aria-label="You have unread notifications" class="Header-link notification-indicator position-relative tooltipped tooltipped-s js-socket-channel js-notification-indicator" data-hotkey="g n" data-ga-click="Header, go to notifications, icon:unread" data-channel="notification-changed:31067101" href="/notifications">
          <span class="mail-status unread"></span>
          <svg class="octicon octicon-bell" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M14 12v1H0v-1l.73-.58c.77-.77.81-2.55 1.19-4.42C2.69 3.23 6 2 6 2c0-.55.45-1 1-1s1 .45 1 1c0 0 3.39 1.23 4.16 5 .38 1.88.42 3.66 1.19 4.42l.66.58H14zm-7 4c1.11 0 2-.89 2-2H5c0 1.11.89 2 2 2z"/></svg>
  </a>
      </div>
  
  
      <div class="Header-item position-relative d-none d-lg-flex">
        <details class="details-overlay details-reset">
    <summary class="Header-link"
        aria-label="Create new…"
        data-ga-click="Header, create new, icon:add">
      <svg class="octicon octicon-plus" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 9H7v5H5V9H0V7h5V2h2v5h5v2z"/></svg> <span class="dropdown-caret"></span>
    </summary>
    <details-menu class="dropdown-menu dropdown-menu-sw">
      
  <a role="menuitem" class="dropdown-item" href="/new" data-ga-click="Header, create new repository">
    New repository
  </a>
  
    <a role="menuitem" class="dropdown-item" href="/new/import" data-ga-click="Header, import a repository">
      Import repository
    </a>
  
  <a role="menuitem" class="dropdown-item" href="https://gist.github.com/" data-ga-click="Header, create new gist">
    New gist
  </a>
  
    <a role="menuitem" class="dropdown-item" href="/organizations/new" data-ga-click="Header, create new organization">
      New organization
    </a>
  
  
    <div role="none" class="dropdown-divider"></div>
    <div class="dropdown-header">
      <span title="williamadba/Public-Presentations">This repository</span>
    </div>
      <a role="menuitem" class="dropdown-item" href="/williamadba/Public-Presentations/issues/new" data-ga-click="Header, create new issue" data-skip-pjax>
        New issue
      </a>
  
  
    </details-menu>
  </details>
  
      </div>
  
      <div class="Header-item position-relative mr-0 d-none d-lg-flex">
        
  <details class="details-overlay details-reset">
    <summary class="Header-link"
      aria-label="View profile and more"
      data-ga-click="Header, show menu, icon:avatar">
      <img alt="@nmbazima" class="avatar" src="https://avatars3.githubusercontent.com/u/31067101?s=40&amp;v=4" height="20" width="20">
      <span class="dropdown-caret"></span>
    </summary>
    <details-menu class="dropdown-menu dropdown-menu-sw mt-2" style="width: 180px">
      <div class="header-nav-current-user css-truncate"><a role="menuitem" class="no-underline user-profile-link px-3 pt-2 pb-2 mb-n2 mt-n1 d-block" href="/nmbazima" data-ga-click="Header, go to profile, text:Signed in as">Signed in as <strong class="css-truncate-target">nmbazima</strong></a></div>
      <div role="none" class="dropdown-divider"></div>
  
        <div class="pl-3 pr-3 f6 user-status-container js-user-status-context pb-1" data-url="/users/status?compact=1&amp;link_mentions=0&amp;truncate=1">
          
  <div class="js-user-status-container
      user-status-compact rounded-1 px-2 py-1 mt-2
      border
    " data-team-hovercards-enabled>
    <details class="js-user-status-details details-reset details-overlay details-overlay-dark">
      <summary class="btn-link btn-block link-gray no-underline js-toggle-user-status-edit toggle-user-status-edit " aria-haspopup="dialog" role="menuitem" data-hydro-click="{&quot;event_type&quot;:&quot;user_profile.click&quot;,&quot;payload&quot;:{&quot;profile_user_id&quot;:6641470,&quot;target&quot;:&quot;EDIT_USER_STATUS&quot;,&quot;user_id&quot;:31067101,&quot;client_id&quot;:&quot;2102328379.1564391750&quot;,&quot;originating_request_id&quot;:&quot;C94B:568D:164C67B:22D7E2E:5D3ECC9C&quot;,&quot;originating_url&quot;:&quot;https://github.com/williamadba/Public-Presentations/blob/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql&quot;,&quot;referrer&quot;:&quot;https://github.com/williamadba/Public-Presentations/tree/master/SQLSat%20Dallas%202019&quot;}}" data-hydro-click-hmac="a245d41b2f73c6c8b531df599a86b751ce6cb4d918fe0937c6c3b9c8ec524d53">
        <div class="d-flex">
          <div class="f6 lh-condensed user-status-header
            d-inline-block v-align-middle
              user-status-emoji-only-header circle
              pr-2
  "
              style="max-width: 29px"
            >
            <div class="user-status-emoji-container flex-shrink-0 mr-1 mt-1 lh-condensed-ultra v-align-bottom" style="">
              <svg class="octicon octicon-smiley" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8 0C3.58 0 0 3.58 0 8s3.58 8 8 8 8-3.58 8-8-3.58-8-8-8zm4.81 12.81a6.72 6.72 0 0 1-2.17 1.45c-.83.36-1.72.53-2.64.53-.92 0-1.81-.17-2.64-.53-.81-.34-1.55-.83-2.17-1.45a6.773 6.773 0 0 1-1.45-2.17A6.59 6.59 0 0 1 1.21 8c0-.92.17-1.81.53-2.64.34-.81.83-1.55 1.45-2.17.62-.62 1.36-1.11 2.17-1.45A6.59 6.59 0 0 1 8 1.21c.92 0 1.81.17 2.64.53.81.34 1.55.83 2.17 1.45.62.62 1.11 1.36 1.45 2.17.36.83.53 1.72.53 2.64 0 .92-.17 1.81-.53 2.64-.34.81-.83 1.55-1.45 2.17zM4 6.8v-.59c0-.66.53-1.19 1.2-1.19h.59c.66 0 1.19.53 1.19 1.19v.59c0 .67-.53 1.2-1.19 1.2H5.2C4.53 8 4 7.47 4 6.8zm5 0v-.59c0-.66.53-1.19 1.2-1.19h.59c.66 0 1.19.53 1.19 1.19v.59c0 .67-.53 1.2-1.19 1.2h-.59C9.53 8 9 7.47 9 6.8zm4 3.2c-.72 1.88-2.91 3-5 3s-4.28-1.13-5-3c-.14-.39.23-1 .66-1h8.59c.41 0 .89.61.75 1z"/></svg>
            </div>
          </div>
          <div class="
            d-inline-block v-align-middle
            
            
             css-truncate css-truncate-target 
             user-status-message-wrapper f6"
             style="line-height: 20px;" >
            <div class="d-inline-block text-gray-dark v-align-text-top text-left">
                <span class="text-gray ml-2">Set status</span>
            </div>
          </div>
        </div>
  </summary>    <details-dialog class="details-dialog rounded-1 anim-fade-in fast Box Box--overlay" role="dialog" tabindex="-1">
        <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="position-relative flex-auto js-user-status-form" action="/users/status?compact=1&amp;link_mentions=0&amp;truncate=1" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="_method" value="put" /><input type="hidden" name="authenticity_token" value="QK7GOoEPuiYC/3Zz98bJdt45J1weNI94nKZWFL9Jnc15lUMNPKPUMSbvX77HVF7FomAK83WFeE6zOIWq5/hqFg==" />
          <div class="Box-header bg-gray border-bottom p-3">
            <button class="Box-btn-octicon js-toggle-user-status-edit btn-octicon float-right" type="reset" aria-label="Close dialog" data-close-dialog>
              <svg class="octicon octicon-x" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.48 8l3.75 3.75-1.48 1.48L6 9.48l-3.75 3.75-1.48-1.48L4.52 8 .77 4.25l1.48-1.48L6 6.52l3.75-3.75 1.48 1.48L7.48 8z"/></svg>
            </button>
            <h3 class="Box-title f5 text-bold text-gray-dark">Edit status</h3>
          </div>
          <input type="hidden" name="emoji" class="js-user-status-emoji-field" value="">
          <input type="hidden" name="organization_id" class="js-user-status-org-id-field" value="">
          <div class="px-3 py-2 text-gray-dark">
            <div class="js-characters-remaining-container position-relative mt-2">
              <div class="input-group d-table form-group my-0 js-user-status-form-group">
                <span class="input-group-button d-table-cell v-align-middle" style="width: 1%">
                  <button type="button" aria-label="Choose an emoji" class="btn-outline btn js-toggle-user-status-emoji-picker btn-open-emoji-picker p-0">
                    <span class="js-user-status-original-emoji" hidden></span>
                    <span class="js-user-status-custom-emoji"></span>
                    <span class="js-user-status-no-emoji-icon" >
                      <svg class="octicon octicon-smiley" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8 0C3.58 0 0 3.58 0 8s3.58 8 8 8 8-3.58 8-8-3.58-8-8-8zm4.81 12.81a6.72 6.72 0 0 1-2.17 1.45c-.83.36-1.72.53-2.64.53-.92 0-1.81-.17-2.64-.53-.81-.34-1.55-.83-2.17-1.45a6.773 6.773 0 0 1-1.45-2.17A6.59 6.59 0 0 1 1.21 8c0-.92.17-1.81.53-2.64.34-.81.83-1.55 1.45-2.17.62-.62 1.36-1.11 2.17-1.45A6.59 6.59 0 0 1 8 1.21c.92 0 1.81.17 2.64.53.81.34 1.55.83 2.17 1.45.62.62 1.11 1.36 1.45 2.17.36.83.53 1.72.53 2.64 0 .92-.17 1.81-.53 2.64-.34.81-.83 1.55-1.45 2.17zM4 6.8v-.59c0-.66.53-1.19 1.2-1.19h.59c.66 0 1.19.53 1.19 1.19v.59c0 .67-.53 1.2-1.19 1.2H5.2C4.53 8 4 7.47 4 6.8zm5 0v-.59c0-.66.53-1.19 1.2-1.19h.59c.66 0 1.19.53 1.19 1.19v.59c0 .67-.53 1.2-1.19 1.2h-.59C9.53 8 9 7.47 9 6.8zm4 3.2c-.72 1.88-2.91 3-5 3s-4.28-1.13-5-3c-.14-.39.23-1 .66-1h8.59c.41 0 .89.61.75 1z"/></svg>
                    </span>
                  </button>
                </span>
                <text-expander keys=": @" data-mention-url="/autocomplete/user-suggestions" data-emoji-url="/autocomplete/emoji">
                  <input
                    type="text"
                    autocomplete="off"
                    data-no-org-url="/autocomplete/user-suggestions"
                    data-org-url="/suggestions?mention_suggester=1"
                    data-maxlength="80"
                    class="d-table-cell width-full form-control js-user-status-message-field js-characters-remaining-field"
                    placeholder="What's happening?"
                    name="message"
                    value=""
                    aria-label="What is your current status?">
                </text-expander>
                <div class="error">Could not update your status, please try again.</div>
              </div>
              <div style="margin-left: 53px" class="my-1 text-small label-characters-remaining js-characters-remaining" data-suffix="remaining" hidden>
                80 remaining
              </div>
            </div>
            <include-fragment class="js-user-status-emoji-picker" data-url="/users/status/emoji"></include-fragment>
            <div class="overflow-auto ml-n3 mr-n3 px-3 border-bottom" style="max-height: 33vh">
              <div class="user-status-suggestions js-user-status-suggestions collapsed overflow-hidden">
                <h4 class="f6 text-normal my-3">Suggestions:</h4>
                <div class="mx-3 mt-2 clearfix">
                    <div class="float-left col-6">
                        <button type="button" value=":palm_tree:" class="d-flex flex-items-baseline flex-items-stretch lh-condensed f6 btn-link link-gray no-underline js-predefined-user-status mb-1">
                          <div class="emoji-status-width mr-2 v-align-middle js-predefined-user-status-emoji">
                            <g-emoji alias="palm_tree" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f334.png">🌴</g-emoji>
                          </div>
                          <div class="d-flex flex-items-center no-underline js-predefined-user-status-message ws-normal text-left" style="border-left: 1px solid transparent">
                            On vacation
                          </div>
                        </button>
                        <button type="button" value=":face_with_thermometer:" class="d-flex flex-items-baseline flex-items-stretch lh-condensed f6 btn-link link-gray no-underline js-predefined-user-status mb-1">
                          <div class="emoji-status-width mr-2 v-align-middle js-predefined-user-status-emoji">
                            <g-emoji alias="face_with_thermometer" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f912.png">🤒</g-emoji>
                          </div>
                          <div class="d-flex flex-items-center no-underline js-predefined-user-status-message ws-normal text-left" style="border-left: 1px solid transparent">
                            Out sick
                          </div>
                        </button>
                    </div>
                    <div class="float-left col-6">
                        <button type="button" value=":house:" class="d-flex flex-items-baseline flex-items-stretch lh-condensed f6 btn-link link-gray no-underline js-predefined-user-status mb-1">
                          <div class="emoji-status-width mr-2 v-align-middle js-predefined-user-status-emoji">
                            <g-emoji alias="house" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f3e0.png">🏠</g-emoji>
                          </div>
                          <div class="d-flex flex-items-center no-underline js-predefined-user-status-message ws-normal text-left" style="border-left: 1px solid transparent">
                            Working from home
                          </div>
                        </button>
                        <button type="button" value=":dart:" class="d-flex flex-items-baseline flex-items-stretch lh-condensed f6 btn-link link-gray no-underline js-predefined-user-status mb-1">
                          <div class="emoji-status-width mr-2 v-align-middle js-predefined-user-status-emoji">
                            <g-emoji alias="dart" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f3af.png">🎯</g-emoji>
                          </div>
                          <div class="d-flex flex-items-center no-underline js-predefined-user-status-message ws-normal text-left" style="border-left: 1px solid transparent">
                            Focusing
                          </div>
                        </button>
                    </div>
                </div>
              </div>
              <div class="user-status-limited-availability-container">
                <div class="form-checkbox my-0">
                  <input type="checkbox" name="limited_availability" value="1" class="js-user-status-limited-availability-checkbox" data-default-message="I may be slow to respond." aria-describedby="limited-availability-help-text-truncate-true-compact-true" id="limited-availability-truncate-true-compact-true">
                  <label class="d-block f5 text-gray-dark mb-1" for="limited-availability-truncate-true-compact-true">
                    Busy
                  </label>
                  <p class="note" id="limited-availability-help-text-truncate-true-compact-true">
                    When others mention you, assign you, or request your review,
                    GitHub will let them know that you have limited availability.
                  </p>
                </div>
              </div>
            </div>
              
  
  <div class="d-inline-block f5 mr-2 pt-3 pb-2" >
    <div class="d-inline-block mr-1">
      Clear status
    </div>
  
    <details class="js-user-status-expire-drop-down f6 dropdown details-reset details-overlay d-inline-block mr-2">
      <summary class="f5 btn-link link-gray-dark border px-2 py-1 rounded-1" aria-haspopup="true">
        <div class="js-user-status-expiration-interval-selected d-inline-block v-align-baseline">
          Never
        </div>
        <div class="dropdown-caret"></div>
      </summary>
  
      <ul class="dropdown-menu dropdown-menu-se pl-0 overflow-auto" style="width: 220px; max-height: 15.5em">
        <li>
          <button type="button" class="btn-link dropdown-item js-user-status-expire-button ws-normal" title="Never">
            <span class="d-inline-block text-bold mb-1">Never</span>
            <div class="f6 lh-condensed">Keep this status until you clear your status or edit your status.</div>
          </button>
        </li>
        <li class="dropdown-divider" role="none"></li>
          <li>
            <button type="button" class="btn-link dropdown-item ws-normal js-user-status-expire-button" title="in 30 minutes" value="2019-07-29T13:08:26+02:00">
              in 30 minutes
            </button>
          </li>
          <li>
            <button type="button" class="btn-link dropdown-item ws-normal js-user-status-expire-button" title="in 1 hour" value="2019-07-29T13:38:26+02:00">
              in 1 hour
            </button>
          </li>
          <li>
            <button type="button" class="btn-link dropdown-item ws-normal js-user-status-expire-button" title="in 4 hours" value="2019-07-29T16:38:26+02:00">
              in 4 hours
            </button>
          </li>
          <li>
            <button type="button" class="btn-link dropdown-item ws-normal js-user-status-expire-button" title="today" value="2019-07-29T23:59:59+02:00">
              today
            </button>
          </li>
          <li>
            <button type="button" class="btn-link dropdown-item ws-normal js-user-status-expire-button" title="this week" value="2019-08-04T23:59:59+02:00">
              this week
            </button>
          </li>
      </ul>
    </details>
    <input class="js-user-status-expiration-date-input" type="hidden" name="expires_at" value="">
  </div>
  
            <include-fragment class="js-user-status-org-picker" data-url="/users/status/organizations"></include-fragment>
          </div>
          <div class="d-flex flex-items-center flex-justify-between p-3 border-top">
            <button type="submit" disabled class="width-full btn btn-primary mr-2 js-user-status-submit">
              Set status
            </button>
            <button type="button" disabled class="width-full js-clear-user-status-button btn ml-2 ">
              Clear status
            </button>
          </div>
  </form>    </details-dialog>
    </details>
  </div>
  
        </div>
        <div role="none" class="dropdown-divider"></div>
  
  
      <a role="menuitem" class="dropdown-item" href="/nmbazima" data-ga-click="Header, go to profile, text:your profile">Your profile</a>
  
  
      <a role="menuitem" class="dropdown-item" href="/nmbazima?tab=repositories" data-ga-click="Header, go to repositories, text:your repositories">Your repositories</a>
  
      <a role="menuitem" class="dropdown-item" href="/nmbazima?tab=projects" data-ga-click="Header, go to projects, text:your projects">Your projects</a>
  
      <a role="menuitem" class="dropdown-item" href="/nmbazima?tab=stars" data-ga-click="Header, go to starred repos, text:your stars">Your stars</a>
        <a role="menuitem" class="dropdown-item" href="https://gist.github.com/mine" data-ga-click="Header, your gists, text:your gists">Your gists</a>
  
  
      <div role="none" class="dropdown-divider"></div>
      <a role="menuitem" class="dropdown-item" href="https://help.github.com" data-ga-click="Header, go to help, text:help">Help</a>
      <a role="menuitem" class="dropdown-item" href="/settings/profile" data-ga-click="Header, go to settings, icon:settings">Settings</a>
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="logout-form" action="/logout" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="pR1P8qwC+j5V3hiF3evRyUcHa1YJ/taMOhScJukFbernGxIPtPPaYmqgMomOYx9SuLuqmN1f1c3N7X08j/mvsg==" />
        
        <button type="submit" class="dropdown-item dropdown-signout" data-ga-click="Header, sign out, icon:logout" role="menuitem">
          Sign out
        </button>
  </form>  </details-menu>
  </details>
  
      </div>
  
    </header>
  
        
  
    </div>
  
    <div id="start-of-content" class="show-on-focus"></div>
  
  
      <div id="js-flash-container">
  
  </div>
  
  
  
    <div class="application-main " data-commit-hovercards-enabled>
          <div itemscope itemtype="http://schema.org/SoftwareSourceCode" class="">
      <main  >
        
  
  
    
  
  
  
  
  
  
  
  
    <div class="pagehead repohead instapaper_ignore readability-menu experiment-repo-nav pt-0 pt-lg-4 ">
      <div class="repohead-details-container clearfix container-lg p-responsive d-none d-lg-block">
  
        <ul class="pagehead-actions">
  
  
  
  
    <li>
      
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form data-remote="true" class="clearfix js-social-form js-social-container" action="/notifications/subscribe" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="ezi7h75Ge2mBpVOdFjRFIryBSvTGo3YM5xHYk8TTWT/Du3/bDnzPd9dR0st2pdIkEXnt8WSDMp88q20LM1HD6Q==" />      <input type="hidden" name="repository_id" value="122529269">
  
        <details class="details-reset details-overlay select-menu float-left">
          <summary class="select-menu-button float-left btn btn-sm btn-with-count" data-hydro-click="{&quot;event_type&quot;:&quot;repository.click&quot;,&quot;payload&quot;:{&quot;target&quot;:&quot;WATCH_BUTTON&quot;,&quot;repository_id&quot;:122529269,&quot;client_id&quot;:&quot;2102328379.1564391750&quot;,&quot;originating_request_id&quot;:&quot;C94B:568D:164C67B:22D7E2E:5D3ECC9C&quot;,&quot;originating_url&quot;:&quot;https://github.com/williamadba/Public-Presentations/blob/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql&quot;,&quot;referrer&quot;:&quot;https://github.com/williamadba/Public-Presentations/tree/master/SQLSat%20Dallas%202019&quot;,&quot;user_id&quot;:31067101}}" data-hydro-click-hmac="cd9f8660a5a05ad24cdb80f420ab50bc612fc31e9246207692119495dd1883e2" data-ga-click="Repository, click Watch settings, action:blob#show">          <span data-menu-button>
                <svg class="octicon octicon-eye v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.06 2C3 2 0 8 0 8s3 6 8.06 6C13 14 16 8 16 8s-3-6-7.94-6zM8 12c-2.2 0-4-1.78-4-4 0-2.2 1.8-4 4-4 2.22 0 4 1.8 4 4 0 2.22-1.78 4-4 4zm2-4c0 1.11-.89 2-2 2-1.11 0-2-.89-2-2 0-1.11.89-2 2-2 1.11 0 2 .89 2 2z"/></svg>
                Watch
            </span>
  </summary>        <details-menu
            class="select-menu-modal position-absolute mt-5"
            style="z-index: 99;">
            <div class="select-menu-header">
              <span class="select-menu-title">Notifications</span>
            </div>
            <div class="select-menu-list">
              <button type="submit" name="do" value="included" class="select-menu-item width-full" aria-checked="true" role="menuitemradio">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <div class="select-menu-item-text">
                  <span class="select-menu-item-heading">Not watching</span>
                  <span class="description">Be notified only when participating or @mentioned.</span>
                  <span class="hidden-select-button-text" data-menu-button-contents>
                    <svg class="octicon octicon-eye v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.06 2C3 2 0 8 0 8s3 6 8.06 6C13 14 16 8 16 8s-3-6-7.94-6zM8 12c-2.2 0-4-1.78-4-4 0-2.2 1.8-4 4-4 2.22 0 4 1.8 4 4 0 2.22-1.78 4-4 4zm2-4c0 1.11-.89 2-2 2-1.11 0-2-.89-2-2 0-1.11.89-2 2-2 1.11 0 2 .89 2 2z"/></svg>
                    Watch
                  </span>
                </div>
              </button>
  
              <button type="submit" name="do" value="release_only" class="select-menu-item width-full" aria-checked="false" role="menuitemradio">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <div class="select-menu-item-text">
                  <span class="select-menu-item-heading">Releases only</span>
                  <span class="description">Be notified of new releases, and when participating or @mentioned.</span>
                  <span class="hidden-select-button-text" data-menu-button-contents>
                    <svg class="octicon octicon-eye v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.06 2C3 2 0 8 0 8s3 6 8.06 6C13 14 16 8 16 8s-3-6-7.94-6zM8 12c-2.2 0-4-1.78-4-4 0-2.2 1.8-4 4-4 2.22 0 4 1.8 4 4 0 2.22-1.78 4-4 4zm2-4c0 1.11-.89 2-2 2-1.11 0-2-.89-2-2 0-1.11.89-2 2-2 1.11 0 2 .89 2 2z"/></svg>
                    Unwatch releases
                  </span>
                </div>
              </button>
  
              <button type="submit" name="do" value="subscribed" class="select-menu-item width-full" aria-checked="false" role="menuitemradio">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <div class="select-menu-item-text">
                  <span class="select-menu-item-heading">Watching</span>
                  <span class="description">Be notified of all conversations.</span>
                  <span class="hidden-select-button-text" data-menu-button-contents>
                    <svg class="octicon octicon-eye v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.06 2C3 2 0 8 0 8s3 6 8.06 6C13 14 16 8 16 8s-3-6-7.94-6zM8 12c-2.2 0-4-1.78-4-4 0-2.2 1.8-4 4-4 2.22 0 4 1.8 4 4 0 2.22-1.78 4-4 4zm2-4c0 1.11-.89 2-2 2-1.11 0-2-.89-2-2 0-1.11.89-2 2-2 1.11 0 2 .89 2 2z"/></svg>
                    Unwatch
                  </span>
                </div>
              </button>
  
              <button type="submit" name="do" value="ignore" class="select-menu-item width-full" aria-checked="false" role="menuitemradio">
                <svg class="octicon octicon-check select-menu-item-icon" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M12 5l-8 8-4-4 1.5-1.5L4 10l6.5-6.5L12 5z"/></svg>
                <div class="select-menu-item-text">
                  <span class="select-menu-item-heading">Ignoring</span>
                  <span class="description">Never be notified.</span>
                  <span class="hidden-select-button-text" data-menu-button-contents>
                    <svg class="octicon octicon-mute v-align-text-bottom" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8 2.81v10.38c0 .67-.81 1-1.28.53L3 10H1c-.55 0-1-.45-1-1V7c0-.55.45-1 1-1h2l3.72-3.72C7.19 1.81 8 2.14 8 2.81zm7.53 3.22l-1.06-1.06-1.97 1.97-1.97-1.97-1.06 1.06L11.44 8 9.47 9.97l1.06 1.06 1.97-1.97 1.97 1.97 1.06-1.06L13.56 8l1.97-1.97z"/></svg>
                    Stop ignoring
                  </span>
                </div>
              </button>
            </div>
          </details-menu>
        </details>
          <a class="social-count js-social-count"
            href="/williamadba/Public-Presentations/watchers"
            aria-label="1 user is watching this repository">
            1
          </a>
  </form>
    </li>
  
    <li>
        <div class="js-toggler-container js-social-container starring-container ">
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="starred js-social-form" action="/williamadba/Public-Presentations/unstar" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="6F/cM7v4PT47I8mj1547IsPBHvtxS38+ROI6s7QR2z5VvqQi7zuuEPaKTfiq366XLqkOI22HUo/PkGMQkalgEw==" />
        <input type="hidden" name="context" value="repository"></input>
        <button type="submit" class="btn btn-sm btn-with-count js-toggler-target" aria-label="Unstar this repository" title="Unstar williamadba/Public-Presentations" data-hydro-click="{&quot;event_type&quot;:&quot;repository.click&quot;,&quot;payload&quot;:{&quot;target&quot;:&quot;UNSTAR_BUTTON&quot;,&quot;repository_id&quot;:122529269,&quot;client_id&quot;:&quot;2102328379.1564391750&quot;,&quot;originating_request_id&quot;:&quot;C94B:568D:164C67B:22D7E2E:5D3ECC9C&quot;,&quot;originating_url&quot;:&quot;https://github.com/williamadba/Public-Presentations/blob/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql&quot;,&quot;referrer&quot;:&quot;https://github.com/williamadba/Public-Presentations/tree/master/SQLSat%20Dallas%202019&quot;,&quot;user_id&quot;:31067101}}" data-hydro-click-hmac="9e46ddf4dc65d05946686988b1b66db781d56bfeff925f0bc9c0f0c29ff842f6" data-ga-click="Repository, click unstar button, action:blob#show; text:Unstar">        <svg class="octicon octicon-star v-align-text-bottom" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M14 6l-4.9-.64L7 1 4.9 5.36 0 6l3.6 3.26L2.67 14 7 11.67 11.33 14l-.93-4.74L14 6z"/></svg>
          Unstar
  </button>        <a class="social-count js-social-count" href="/williamadba/Public-Presentations/stargazers"
             aria-label="0 users starred this repository">
             0
          </a>
  </form>
      <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="unstarred js-social-form" action="/williamadba/Public-Presentations/star" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="lJMemhVh/8Md14VUuANJdPa522rxPHyLuGHhFJosnWXYX1kVGxBYTzezJ26UT17zICpbE94pNWk2qxT9II44yw==" />
        <input type="hidden" name="context" value="repository"></input>
        <button type="submit" class="btn btn-sm btn-with-count js-toggler-target" aria-label="Unstar this repository" title="Star williamadba/Public-Presentations" data-hydro-click="{&quot;event_type&quot;:&quot;repository.click&quot;,&quot;payload&quot;:{&quot;target&quot;:&quot;STAR_BUTTON&quot;,&quot;repository_id&quot;:122529269,&quot;client_id&quot;:&quot;2102328379.1564391750&quot;,&quot;originating_request_id&quot;:&quot;C94B:568D:164C67B:22D7E2E:5D3ECC9C&quot;,&quot;originating_url&quot;:&quot;https://github.com/williamadba/Public-Presentations/blob/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql&quot;,&quot;referrer&quot;:&quot;https://github.com/williamadba/Public-Presentations/tree/master/SQLSat%20Dallas%202019&quot;,&quot;user_id&quot;:31067101}}" data-hydro-click-hmac="ea4f61f5af833706768d2af5c0d23cc628dc18f46c36d5b4fe18274c0e976372" data-ga-click="Repository, click star button, action:blob#show; text:Star">        <svg class="octicon octicon-star v-align-text-bottom" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M14 6l-4.9-.64L7 1 4.9 5.36 0 6l3.6 3.26L2.67 14 7 11.67 11.33 14l-.93-4.74L14 6z"/></svg>
          Star
  </button>        <a class="social-count js-social-count" href="/williamadba/Public-Presentations/stargazers"
             aria-label="0 users starred this repository">
            0
          </a>
  </form>  </div>
  
    </li>
  
    <li>
            <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="btn-with-count" action="/williamadba/Public-Presentations/fork" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="O8HxeBoH6CPFSqt4aWz/QmdgB48hPxRuIWQXP/uF+VdX33iuoXxkNCRKIkCVumPkw+bP46Wf52KLG8OW+W9A5A==" />
              <button class="btn btn-sm btn-with-count" data-hydro-click="{&quot;event_type&quot;:&quot;repository.click&quot;,&quot;payload&quot;:{&quot;target&quot;:&quot;FORK_BUTTON&quot;,&quot;repository_id&quot;:122529269,&quot;client_id&quot;:&quot;2102328379.1564391750&quot;,&quot;originating_request_id&quot;:&quot;C94B:568D:164C67B:22D7E2E:5D3ECC9C&quot;,&quot;originating_url&quot;:&quot;https://github.com/williamadba/Public-Presentations/blob/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql&quot;,&quot;referrer&quot;:&quot;https://github.com/williamadba/Public-Presentations/tree/master/SQLSat%20Dallas%202019&quot;,&quot;user_id&quot;:31067101}}" data-hydro-click-hmac="e7360be45f2bedf69c7d94a5579477ba355679491829671bd277e9338b6af498" data-ga-click="Repository, show fork modal, action:blob#show; text:Fork" type="submit" title="Fork your own copy of williamadba/Public-Presentations to your account" aria-label="Fork your own copy of williamadba/Public-Presentations to your account">              <svg class="octicon octicon-repo-forked v-align-text-bottom" viewBox="0 0 10 16" version="1.1" width="10" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8 1a1.993 1.993 0 0 0-1 3.72V6L5 8 3 6V4.72A1.993 1.993 0 0 0 2 1a1.993 1.993 0 0 0-1 3.72V6.5l3 3v1.78A1.993 1.993 0 0 0 5 15a1.993 1.993 0 0 0 1-3.72V9.5l3-3V4.72A1.993 1.993 0 0 0 8 1zM2 4.2C1.34 4.2.8 3.65.8 3c0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2zm3 10c-.66 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2zm3-10c-.66 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2z"/></svg>
                Fork
  </button></form>
      <a href="/williamadba/Public-Presentations/network/members" class="social-count"
         aria-label="1 user forked this repository">
        1
      </a>
    </li>
  </ul>
  
        <h1 class="public ">
      <svg class="octicon octicon-repo" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M4 9H3V8h1v1zm0-3H3v1h1V6zm0-2H3v1h1V4zm0-2H3v1h1V2zm8-1v12c0 .55-.45 1-1 1H6v2l-1.5-1.5L3 16v-2H1c-.55 0-1-.45-1-1V1c0-.55.45-1 1-1h10c.55 0 1 .45 1 1zm-1 10H1v2h2v-1h3v1h5v-2zm0-10H2v9h9V1z"/></svg>
    <span class="author" itemprop="author"><a class="url fn" rel="author" data-hovercard-type="user" data-hovercard-url="/hovercards?user_id=6641470" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="/williamadba">williamadba</a></span><!--
  --><span class="path-divider">/</span><!--
  --><strong itemprop="name"><a data-pjax="#js-repo-pjax-container" href="/williamadba/Public-Presentations">Public-Presentations</a></strong>
    
  
  </h1>
  
      </div>
      
  <nav class="hx_reponav reponav js-repo-nav js-sidenav-container-pjax container-lg p-responsive d-none d-lg-block"
       itemscope
       itemtype="http://schema.org/BreadcrumbList"
      aria-label="Repository"
       data-pjax="#js-repo-pjax-container">
  
    <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
      <a class="js-selected-navigation-item selected reponav-item" itemprop="url" data-hotkey="g c" aria-current="page" data-selected-links="repo_source repo_downloads repo_commits repo_releases repo_tags repo_branches repo_packages /williamadba/Public-Presentations" href="/williamadba/Public-Presentations">
        <svg class="octicon octicon-code" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M9.5 3L8 4.5 11.5 8 8 11.5 9.5 13 14 8 9.5 3zm-5 0L0 8l4.5 5L6 11.5 2.5 8 6 4.5 4.5 3z"/></svg>
        <span itemprop="name">Code</span>
        <meta itemprop="position" content="1">
  </a>  </span>
  
      <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
        <a itemprop="url" data-hotkey="g i" class="js-selected-navigation-item reponav-item" data-selected-links="repo_issues repo_labels repo_milestones /williamadba/Public-Presentations/issues" href="/williamadba/Public-Presentations/issues">
          <svg class="octicon octicon-issue-opened" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7 2.3c3.14 0 5.7 2.56 5.7 5.7s-2.56 5.7-5.7 5.7A5.71 5.71 0 0 1 1.3 8c0-3.14 2.56-5.7 5.7-5.7zM7 1C3.14 1 0 4.14 0 8s3.14 7 7 7 7-3.14 7-7-3.14-7-7-7zm1 3H6v5h2V4zm0 6H6v2h2v-2z"/></svg>
          <span itemprop="name">Issues</span>
          <span class="Counter">0</span>
          <meta itemprop="position" content="2">
  </a>    </span>
  
    <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
      <a data-hotkey="g p" itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="repo_pulls checks /williamadba/Public-Presentations/pulls" href="/williamadba/Public-Presentations/pulls">
        <svg class="octicon octicon-git-pull-request" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M11 11.28V5c-.03-.78-.34-1.47-.94-2.06C9.46 2.35 8.78 2.03 8 2H7V0L4 3l3 3V4h1c.27.02.48.11.69.31.21.2.3.42.31.69v6.28A1.993 1.993 0 0 0 10 15a1.993 1.993 0 0 0 1-3.72zm-1 2.92c-.66 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2zM4 3c0-1.11-.89-2-2-2a1.993 1.993 0 0 0-1 3.72v6.56A1.993 1.993 0 0 0 2 15a1.993 1.993 0 0 0 1-3.72V4.72c.59-.34 1-.98 1-1.72zm-.8 10c0 .66-.55 1.2-1.2 1.2-.65 0-1.2-.55-1.2-1.2 0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2zM2 4.2C1.34 4.2.8 3.65.8 3c0-.65.55-1.2 1.2-1.2.65 0 1.2.55 1.2 1.2 0 .65-.55 1.2-1.2 1.2z"/></svg>
        <span itemprop="name">Pull requests</span>
        <span class="Counter">0</span>
        <meta itemprop="position" content="3">
  </a>  </span>
  
  
      <a data-hotkey="g b" class="js-selected-navigation-item reponav-item" data-selected-links="repo_projects new_repo_project repo_project /williamadba/Public-Presentations/projects" href="/williamadba/Public-Presentations/projects">
        <svg class="octicon octicon-project" viewBox="0 0 15 16" version="1.1" width="15" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M10 12h3V2h-3v10zm-4-2h3V2H6v8zm-4 4h3V2H2v12zm-1 1h13V1H1v14zM14 0H1a1 1 0 0 0-1 1v14a1 1 0 0 0 1 1h13a1 1 0 0 0 1-1V1a1 1 0 0 0-1-1z"/></svg>
        Projects
        <span class="Counter" >0</span>
  </a>
  
      <a class="js-selected-navigation-item reponav-item" data-hotkey="g w" data-selected-links="repo_wiki /williamadba/Public-Presentations/wiki" href="/williamadba/Public-Presentations/wiki">
        <svg class="octicon octicon-book" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M3 5h4v1H3V5zm0 3h4V7H3v1zm0 2h4V9H3v1zm11-5h-4v1h4V5zm0 2h-4v1h4V7zm0 2h-4v1h4V9zm2-6v9c0 .55-.45 1-1 1H9.5l-1 1-1-1H2c-.55 0-1-.45-1-1V3c0-.55.45-1 1-1h5.5l1 1 1-1H15c.55 0 1 .45 1 1zm-8 .5L7.5 3H2v9h6V3.5zm7-.5H9.5l-.5.5V12h6V3z"/></svg>
        Wiki
  </a>
      <a data-skip-pjax="true" class="js-selected-navigation-item reponav-item" data-selected-links="security alerts policy /williamadba/Public-Presentations/security/advisories" href="/williamadba/Public-Presentations/security/advisories">
        <svg class="octicon octicon-shield" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M0 2l7-2 7 2v6.02C14 12.69 8.69 16 7 16c-1.69 0-7-3.31-7-7.98V2zm1 .75L7 1l6 1.75v5.268C13 12.104 8.449 15 7 15c-1.449 0-6-2.896-6-6.982V2.75zm1 .75L7 2v12c-1.207 0-5-2.482-5-5.985V3.5z"/></svg>
        Security
  </a>
      <a class="js-selected-navigation-item reponav-item" data-selected-links="repo_graphs repo_contributors dependency_graph pulse people /williamadba/Public-Presentations/pulse" href="/williamadba/Public-Presentations/pulse">
        <svg class="octicon octicon-graph" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M16 14v1H0V0h1v14h15zM5 13H3V8h2v5zm4 0H7V3h2v10zm4 0h-2V6h2v7z"/></svg>
        Insights
  </a>
  
  </nav>
  
    <div class="reponav-wrapper reponav-small d-lg-none">
    <nav class="reponav js-reponav text-center no-wrap"
         itemscope
         itemtype="http://schema.org/BreadcrumbList">
  
      <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
        <a class="js-selected-navigation-item selected reponav-item" itemprop="url" aria-current="page" data-selected-links="repo_source repo_downloads repo_commits repo_releases repo_tags repo_branches repo_packages /williamadba/Public-Presentations" href="/williamadba/Public-Presentations">
          <span itemprop="name">Code</span>
          <meta itemprop="position" content="1">
  </a>    </span>
  
        <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
          <a itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="repo_issues repo_labels repo_milestones /williamadba/Public-Presentations/issues" href="/williamadba/Public-Presentations/issues">
            <span itemprop="name">Issues</span>
            <span class="Counter">0</span>
            <meta itemprop="position" content="2">
  </a>      </span>
  
      <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
        <a itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="repo_pulls checks /williamadba/Public-Presentations/pulls" href="/williamadba/Public-Presentations/pulls">
          <span itemprop="name">Pull requests</span>
          <span class="Counter">0</span>
          <meta itemprop="position" content="3">
  </a>    </span>
  
        <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
          <a itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="repo_projects new_repo_project repo_project /williamadba/Public-Presentations/projects" href="/williamadba/Public-Presentations/projects">
            <span itemprop="name">Projects</span>
            <span class="Counter">0</span>
            <meta itemprop="position" content="4">
  </a>      </span>
  
        <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
          <a itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="repo_wiki /williamadba/Public-Presentations/wiki" href="/williamadba/Public-Presentations/wiki">
            <span itemprop="name">Wiki</span>
            <meta itemprop="position" content="5">
  </a>      </span>
  
        <a itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="security alerts policy /williamadba/Public-Presentations/security/advisories" href="/williamadba/Public-Presentations/security/advisories">
          <span itemprop="name">Security</span>
          <meta itemprop="position" content="6">
  </a>
        <a class="js-selected-navigation-item reponav-item" data-selected-links="pulse /williamadba/Public-Presentations/pulse" href="/williamadba/Public-Presentations/pulse">
          Pulse
  </a>
        <span itemscope itemtype="http://schema.org/ListItem" itemprop="itemListElement">
          <a itemprop="url" class="js-selected-navigation-item reponav-item" data-selected-links="community /williamadba/Public-Presentations/community" href="/williamadba/Public-Presentations/community">
            Community
  </a>      </span>
  
    </nav>
  </div>
  
  
    </div>
  <div class="container-lg clearfix new-discussion-timeline experiment-repo-nav  p-responsive">
    <div class="repository-content ">
  
      
      
  
  
    
      <a class="d-none js-permalink-shortcut" data-hotkey="y" href="/williamadba/Public-Presentations/blob/173191158d6fd1a608f2d39495ffdea7e9fac063/SQLSat%20Dallas%202019/security%20Script%20databases.sql">Permalink</a>
  
      <!-- blob contrib key: blob_contributors:v21:b94be50c3ee1c2e956d5d7faa72dde7d -->
        
  
      <div class="d-flex flex-items-start flex-shrink-0 mb-2 flex-column flex-md-row">
        <span class="d-flex flex-justify-between width-full width-md-auto">
          
  <details class="details-reset details-overlay select-menu branch-select-menu  hx_rsm" id="branch-select-menu">
    <summary class="btn btn-sm select-menu-button css-truncate"
             data-hotkey="w"
             
             title="Switch branches or tags">
      <i>Branch:</i>
      <span class="css-truncate-target">master</span>
    </summary>
  
    <details-menu class="select-menu-modal hx_rsm-modal position-absolute" style="z-index: 99;" src="/williamadba/Public-Presentations/ref-list/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql?source_action=show&amp;source_controller=blob" preload>
      <include-fragment class="select-menu-loading-overlay anim-pulse">
        <svg height="32" class="octicon octicon-octoface" viewBox="0 0 16 16" version="1.1" width="32" aria-hidden="true"><path fill-rule="evenodd" d="M14.7 5.34c.13-.32.55-1.59-.13-3.31 0 0-1.05-.33-3.44 1.3-1-.28-2.07-.32-3.13-.32s-2.13.04-3.13.32c-2.39-1.64-3.44-1.3-3.44-1.3-.68 1.72-.26 2.99-.13 3.31C.49 6.21 0 7.33 0 8.69 0 13.84 3.33 15 7.98 15S16 13.84 16 8.69c0-1.36-.49-2.48-1.3-3.35zM8 14.02c-3.3 0-5.98-.15-5.98-3.35 0-.76.38-1.48 1.02-2.07 1.07-.98 2.9-.46 4.96-.46 2.07 0 3.88-.52 4.96.46.65.59 1.02 1.3 1.02 2.07 0 3.19-2.68 3.35-5.98 3.35zM5.49 9.01c-.66 0-1.2.8-1.2 1.78s.54 1.79 1.2 1.79c.66 0 1.2-.8 1.2-1.79s-.54-1.78-1.2-1.78zm5.02 0c-.66 0-1.2.79-1.2 1.78s.54 1.79 1.2 1.79c.66 0 1.2-.8 1.2-1.79s-.53-1.78-1.2-1.78z"/></svg>
      </include-fragment>
    </details-menu>
  </details>
  
          <div class="BtnGroup flex-shrink-0 d-md-none">
            <a href="/williamadba/Public-Presentations/find/master"
                  class="js-pjax-capture-input btn btn-sm BtnGroup-item"
                  data-pjax
                  data-hotkey="t">
              Find file
            </a>
            <clipboard-copy value="SQLSat Dallas 2019/security Script databases.sql" class="btn btn-sm BtnGroup-item">
              Copy path
            </clipboard-copy>
          </div>
        </span>
        <h2 id="blob-path" class="breadcrumb flex-auto min-width-0 text-normal flex-md-self-center ml-md-2 mr-md-3 my-2 my-md-0">
          <span class="js-repo-root text-bold"><span class="js-path-segment"><a data-pjax="true" href="/williamadba/Public-Presentations"><span>Public-Presentations</span></a></span></span><span class="separator">/</span><span class="js-path-segment"><a data-pjax="true" href="/williamadba/Public-Presentations/tree/master/SQLSat%20Dallas%202019"><span>SQLSat Dallas 2019</span></a></span><span class="separator">/</span><strong class="final-path">security Script databases.sql</strong>
        </h2>
  
        <div class="BtnGroup flex-shrink-0 d-none d-md-inline-block">
          <a href="/williamadba/Public-Presentations/find/master"
                class="js-pjax-capture-input btn btn-sm BtnGroup-item"
                data-pjax
                data-hotkey="t">
            Find file
          </a>
          <clipboard-copy value="SQLSat Dallas 2019/security Script databases.sql" class="btn btn-sm BtnGroup-item">
            Copy path
          </clipboard-copy>
        </div>
      </div>
  
  
  
      <include-fragment src="/williamadba/Public-Presentations/contributors/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql" class="Box Box--condensed commit-loader">
        <div class="Box-body bg-blue-light f6">
          Fetching contributors&hellip;
        </div>
  
        <div class="Box-body d-flex flex-items-center" >
            <img alt="" class="loader-loading mr-2" src="https://github.githubassets.com/images/spinners/octocat-spinner-32-EAF2F5.gif" width="16" height="16" />
          <span class="text-red h6 loader-error">Cannot retrieve contributors at this time</span>
        </div>
  </include-fragment>
  
  
  
  
      <div class="Box mt-3 position-relative">
        
  <div class="Box-header py-2 d-flex flex-column flex-shrink-0 flex-md-row flex-md-items-center">
  
    <div class="text-mono f6 flex-auto pr-3 flex-order-2 flex-md-order-1 mt-2 mt-md-0">
        213 lines (199 sloc)
        <span class="file-info-divider"></span>
      13.1 KB
    </div>
  
    <div class="d-flex py-1 py-md-0 flex-auto flex-order-1 flex-md-order-2 flex-sm-grow-0 flex-justify-between">
  
      <div class="BtnGroup">
        <a id="raw-url" class="btn btn-sm BtnGroup-item" href="/williamadba/Public-Presentations/raw/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql">Raw</a>
          <a class="btn btn-sm js-update-url-with-hash BtnGroup-item" data-hotkey="b" href="/williamadba/Public-Presentations/blame/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql">Blame</a>
        <a rel="nofollow" class="btn btn-sm BtnGroup-item" href="/williamadba/Public-Presentations/commits/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql">History</a>
      </div>
  
  
      <div>
              <a class="btn-octicon tooltipped tooltipped-nw hide-sm"
                 href="x-github-client://openRepo/https://github.com/williamadba/Public-Presentations?branch=master&amp;filepath=SQLSat%20Dallas%202019%2Fsecurity%20Script%20databases.sql"
                 aria-label="Open this file in GitHub Desktop"
                 data-ga-click="Repository, open with desktop, type:windows">
                  <svg class="octicon octicon-device-desktop" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M15 2H1c-.55 0-1 .45-1 1v9c0 .55.45 1 1 1h5.34c-.25.61-.86 1.39-2.34 2h8c-1.48-.61-2.09-1.39-2.34-2H15c.55 0 1-.45 1-1V3c0-.55-.45-1-1-1zm0 9H1V3h14v8z"/></svg>
              </a>
  
              <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="inline-form js-update-url-with-hash" action="/williamadba/Public-Presentations/edit/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="Wa0hxPda2hiTtIFEKq0WkiRkvKUfWsv1eQc5E+HavHt1d6upPFCmEcyvKpIBn5zALsMEIQhLgbLrAaSAJc7oKg==" />
                <button class="btn-octicon tooltipped tooltipped-nw" type="submit"
                  aria-label="Fork this project and edit the file" data-hotkey="e" data-disable-with>
                  <svg class="octicon octicon-pencil" viewBox="0 0 14 16" version="1.1" width="14" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M0 12v3h3l8-8-3-3-8 8zm3 2H1v-2h1v1h1v1zm10.3-9.3L12 6 9 3l1.3-1.3a.996.996 0 0 1 1.41 0l1.59 1.59c.39.39.39 1.02 0 1.41z"/></svg>
                </button>
  </form>
            <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="inline-form" action="/williamadba/Public-Presentations/delete/master/SQLSat%20Dallas%202019/security%20Script%20databases.sql" accept-charset="UTF-8" method="post"><input name="utf8" type="hidden" value="&#x2713;" /><input type="hidden" name="authenticity_token" value="wQTWixW3nxDhFbrycVKU0bH06xyMVOe0q56zfVddlD+y+XffAVaeb3e0vDWpdXNfxGUVBMwVirsWaTXOvXaw8w==" />
              <button class="btn-octicon btn-octicon-danger tooltipped tooltipped-nw" type="submit"
                aria-label="Fork this project and delete the file" data-disable-with>
                <svg class="octicon octicon-trashcan" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M11 2H9c0-.55-.45-1-1-1H5c-.55 0-1 .45-1 1H2c-.55 0-1 .45-1 1v1c0 .55.45 1 1 1v9c0 .55.45 1 1 1h7c.55 0 1-.45 1-1V5c.55 0 1-.45 1-1V3c0-.55-.45-1-1-1zm-1 12H3V5h1v8h1V5h1v8h1V5h1v8h1V5h1v9zm1-10H2V3h9v1z"/></svg>
              </button>
  </form>    </div>
    </div>
  </div>
  
  
  
  
        
  
    <div itemprop="text" class="Box-body p-0 blob-wrapper data type-tsql ">
        
  <table class="highlight tab-size js-file-line-container" data-tab-size="8">
        <tr>
          <td id="L1" class="blob-num js-line-number" data-line-number="1"></td>
          <td id="LC1" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Script out Database-level permissions</span></td>
        </tr>
        <tr>
          <td id="L2" class="blob-num js-line-number" data-line-number="2"></td>
          <td id="LC2" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>See also Security Script 2012.sql</span></td>
        </tr>
        <tr>
          <td id="L3" class="blob-num js-line-number" data-line-number="3"></td>
          <td id="LC3" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L4" class="blob-num js-line-number" data-line-number="4"></td>
          <td id="LC4" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Database role membership</span></td>
        </tr>
        <tr>
          <td id="L5" class="blob-num js-line-number" data-line-number="5"></td>
          <td id="LC5" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L6" class="blob-num js-line-number" data-line-number="6"></td>
          <td id="LC6" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Single Database</span></td>
        </tr>
        <tr>
          <td id="L7" class="blob-num js-line-number" data-line-number="7"></td>
          <td id="LC7" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Run on each database for database-level security.</span></td>
        </tr>
        <tr>
          <td id="L8" class="blob-num js-line-number" data-line-number="8"></td>
          <td id="LC8" class="blob-code blob-code-inner js-file-line"><span class="pl-k">SELECT</span> <span class="pl-c1">DB_NAME</span>();</td>
        </tr>
        <tr>
          <td id="L9" class="blob-num js-line-number" data-line-number="9"></td>
          <td id="LC9" class="blob-code blob-code-inner js-file-line"><span class="pl-k">SELECT DISTINCT</span>	<span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">r</span>.<span class="pl-c1">name</span>) <span class="pl-k">as</span> database_role_name, <span class="pl-c1">r</span>.<span class="pl-c1">type_desc</span>, <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">d</span>.<span class="pl-c1">name</span>) <span class="pl-k">as</span> principal_name, <span class="pl-c1">d</span>.<span class="pl-c1">type_desc</span></td>
        </tr>
        <tr>
          <td id="L10" class="blob-num js-line-number" data-line-number="10"></td>
          <td id="LC10" class="blob-code blob-code-inner js-file-line">,	Add_TSQL <span class="pl-k">=</span> <span class="pl-s"><span class="pl-pds">&#39;</span>EXEC sp_addrolemember @membername = N&#39;<span class="pl-pds">&#39;</span>&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">d</span>.<span class="pl-c1">name</span> COLLATE DATABASE_DEFAULT <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>&#39;<span class="pl-pds">&#39;</span>, @rolename = N&#39;<span class="pl-pds">&#39;</span>&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">r</span>.<span class="pl-c1">name</span> <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>&#39;<span class="pl-pds">&#39;</span>&#39;</span></td>
        </tr>
        <tr>
          <td id="L11" class="blob-num js-line-number" data-line-number="11"></td>
          <td id="LC11" class="blob-code blob-code-inner js-file-line">,	Drop_TSQL <span class="pl-k">=</span> <span class="pl-s"><span class="pl-pds">&#39;</span>EXEC sp_droprolemember @membername = N&#39;<span class="pl-pds">&#39;</span>&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">d</span>.<span class="pl-c1">name</span> COLLATE DATABASE_DEFAULT <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>&#39;<span class="pl-pds">&#39;</span>, @rolename = N&#39;<span class="pl-pds">&#39;</span>&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">r</span>.<span class="pl-c1">name</span> <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>&#39;<span class="pl-pds">&#39;</span>&#39;</span></td>
        </tr>
        <tr>
          <td id="L12" class="blob-num js-line-number" data-line-number="12"></td>
          <td id="LC12" class="blob-code blob-code-inner js-file-line"><span class="pl-k">FROM</span>	<span class="pl-c1">sys</span>.<span class="pl-c1">database_role_members</span> rm</td>
        </tr>
        <tr>
          <td id="L13" class="blob-num js-line-number" data-line-number="13"></td>
          <td id="LC13" class="blob-code blob-code-inner js-file-line"><span class="pl-k">inner join</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_principals</span> r <span class="pl-k">on</span> <span class="pl-c1">rm</span>.<span class="pl-c1">role_principal_id</span> <span class="pl-k">=</span> <span class="pl-c1">r</span>.<span class="pl-c1">principal_id</span></td>
        </tr>
        <tr>
          <td id="L14" class="blob-num js-line-number" data-line-number="14"></td>
          <td id="LC14" class="blob-code blob-code-inner js-file-line"><span class="pl-k">inner join</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_principals</span> d <span class="pl-k">on</span> <span class="pl-c1">rm</span>.<span class="pl-c1">member_principal_id</span> <span class="pl-k">=</span> <span class="pl-c1">d</span>.<span class="pl-c1">principal_id</span></td>
        </tr>
        <tr>
          <td id="L15" class="blob-num js-line-number" data-line-number="15"></td>
          <td id="LC15" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">/*</span></span></td>
        </tr>
        <tr>
          <td id="L16" class="blob-num js-line-number" data-line-number="16"></td>
          <td id="LC16" class="blob-code blob-code-inner js-file-line"><span class="pl-c">--Multi Database</span></td>
        </tr>
        <tr>
          <td id="L17" class="blob-num js-line-number" data-line-number="17"></td>
          <td id="LC17" class="blob-code blob-code-inner js-file-line"><span class="pl-c">declare @tsql nvarchar(4000) = &#39;use [?]; </span></td>
        </tr>
        <tr>
          <td id="L18" class="blob-num js-line-number" data-line-number="18"></td>
          <td id="LC18" class="blob-code blob-code-inner js-file-line"><span class="pl-c">SELECT DB_NAME();</span></td>
        </tr>
        <tr>
          <td id="L19" class="blob-num js-line-number" data-line-number="19"></td>
          <td id="LC19" class="blob-code blob-code-inner js-file-line"><span class="pl-c">SELECT DISTINCT	QUOTENAME(r.name) as database_role_name, r.type_desc, QUOTENAME(d.name) as principal_name, d.type_desc</span></td>
        </tr>
        <tr>
          <td id="L20" class="blob-num js-line-number" data-line-number="20"></td>
          <td id="LC20" class="blob-code blob-code-inner js-file-line"><span class="pl-c">,	Add_TSQL = &#39;&#39;EXEC sp_addrolemember @membername = N&#39;&#39;&#39;&#39;&#39;&#39; + d.name COLLATE DATABASE_DEFAULT + &#39;&#39;&#39;&#39;&#39;&#39;, @rolename = N&#39;&#39;&#39;&#39;&#39;&#39; + r.name + &#39;&#39;&#39;&#39;&#39;&#39;&#39;&#39;</span></td>
        </tr>
        <tr>
          <td id="L21" class="blob-num js-line-number" data-line-number="21"></td>
          <td id="LC21" class="blob-code blob-code-inner js-file-line"><span class="pl-c">,	Drop_TSQL = &#39;&#39;EXEC sp_droprolemember @membername = N&#39;&#39;&#39;&#39;&#39;&#39; + d.name COLLATE DATABASE_DEFAULT + &#39;&#39;&#39;&#39;&#39;&#39;, @rolename = N&#39;&#39;&#39;&#39;&#39;&#39; + r.name + &#39;&#39;&#39;&#39;&#39;&#39;&#39;&#39;</span></td>
        </tr>
        <tr>
          <td id="L22" class="blob-num js-line-number" data-line-number="22"></td>
          <td id="LC22" class="blob-code blob-code-inner js-file-line"><span class="pl-c">FROM	sys.database_role_members rm</span></td>
        </tr>
        <tr>
          <td id="L23" class="blob-num js-line-number" data-line-number="23"></td>
          <td id="LC23" class="blob-code blob-code-inner js-file-line"><span class="pl-c">inner join sys.database_principals r on rm.role_principal_id = r.principal_id</span></td>
        </tr>
        <tr>
          <td id="L24" class="blob-num js-line-number" data-line-number="24"></td>
          <td id="LC24" class="blob-code blob-code-inner js-file-line"><span class="pl-c">inner join sys.database_principals d on rm.member_principal_id = d.principal_id</span></td>
        </tr>
        <tr>
          <td id="L25" class="blob-num js-line-number" data-line-number="25"></td>
          <td id="LC25" class="blob-code blob-code-inner js-file-line"><span class="pl-c">&#39;;</span></td>
        </tr>
        <tr>
          <td id="L26" class="blob-num js-line-number" data-line-number="26"></td>
          <td id="LC26" class="blob-code blob-code-inner js-file-line"><span class="pl-c">exec sp_msforeachdb @tsql</span></td>
        </tr>
        <tr>
          <td id="L27" class="blob-num js-line-number" data-line-number="27"></td>
          <td id="LC27" class="blob-code blob-code-inner js-file-line"><span class="pl-c">go</span></td>
        </tr>
        <tr>
          <td id="L28" class="blob-num js-line-number" data-line-number="28"></td>
          <td id="LC28" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">*/</span></span></td>
        </tr>
        <tr>
          <td id="L29" class="blob-num js-line-number" data-line-number="29"></td>
          <td id="LC29" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L30" class="blob-num js-line-number" data-line-number="30"></td>
          <td id="LC30" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L31" class="blob-num js-line-number" data-line-number="31"></td>
          <td id="LC31" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Database Permissions</span></td>
        </tr>
        <tr>
          <td id="L32" class="blob-num js-line-number" data-line-number="32"></td>
          <td id="LC32" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Run on each database for database-level security.</span></td>
        </tr>
        <tr>
          <td id="L33" class="blob-num js-line-number" data-line-number="33"></td>
          <td id="LC33" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L34" class="blob-num js-line-number" data-line-number="34"></td>
          <td id="LC34" class="blob-code blob-code-inner js-file-line"><span class="pl-k">SELECT</span> <span class="pl-c1">DB_NAME</span>();</td>
        </tr>
        <tr>
          <td id="L35" class="blob-num js-line-number" data-line-number="35"></td>
          <td id="LC35" class="blob-code blob-code-inner js-file-line"><span class="pl-k">SELECT</span>	Permission_State_Desc	<span class="pl-k">=</span>	<span class="pl-c1">perm</span>.<span class="pl-c1">state_desc</span></td>
        </tr>
        <tr>
          <td id="L36" class="blob-num js-line-number" data-line-number="36"></td>
          <td id="LC36" class="blob-code blob-code-inner js-file-line">    ,	Permission_Name			<span class="pl-k">=</span>	<span class="pl-c1">perm</span>.<span class="pl-c1">permission_name</span> </td>
        </tr>
        <tr>
          <td id="L37" class="blob-num js-line-number" data-line-number="37"></td>
          <td id="LC37" class="blob-code blob-code-inner js-file-line">    ,	Permission_Object_Name	<span class="pl-k">=</span> <span class="pl-c1">ISNULL</span>(<span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">s</span>.<span class="pl-c1">name</span> ) <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>.&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>&#39;</span>) <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">obj</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">+</span> <span class="pl-k">CASE</span> <span class="pl-k">WHEN</span> <span class="pl-c1">cl</span>.<span class="pl-c1">name</span> COLLATE database_default <span class="pl-k">is</span> <span class="pl-k">null</span> <span class="pl-k">THEN</span> <span class="pl-s"><span class="pl-pds">&#39;</span>&#39;</span> <span class="pl-k">ELSE</span> <span class="pl-s"><span class="pl-pds">&#39;</span>.&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">cl</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">END</span> 			</td>
        </tr>
        <tr>
          <td id="L38" class="blob-num js-line-number" data-line-number="38"></td>
          <td id="LC38" class="blob-code blob-code-inner js-file-line">	,	Object_Type_Desc		<span class="pl-k">=</span>	<span class="pl-c1">obj</span>.<span class="pl-c1">type_desc</span>   </td>
        </tr>
        <tr>
          <td id="L39" class="blob-num js-line-number" data-line-number="39"></td>
          <td id="LC39" class="blob-code blob-code-inner js-file-line">    ,	Principal_Name			<span class="pl-k">=</span>	<span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">u</span>.<span class="pl-c1">name</span> COLLATE database_default) </td>
        </tr>
        <tr>
          <td id="L40" class="blob-num js-line-number" data-line-number="40"></td>
          <td id="LC40" class="blob-code blob-code-inner js-file-line">    ,	User_Type				<span class="pl-k">=</span>	<span class="pl-c1">u</span>.<span class="pl-c1">type_desc</span> </td>
        </tr>
        <tr>
          <td id="L41" class="blob-num js-line-number" data-line-number="41"></td>
          <td id="LC41" class="blob-code blob-code-inner js-file-line">	,	Create_TSQL <span class="pl-k">=</span> <span class="pl-c1">perm</span>.<span class="pl-c1">state_desc</span> <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">N</span><span class="pl-pds">&#39;</span> &#39;</span> <span class="pl-k">+</span> <span class="pl-c1">perm</span>.<span class="pl-c1">permission_name</span> </td>
        </tr>
        <tr>
          <td id="L42" class="blob-num js-line-number" data-line-number="42"></td>
          <td id="LC42" class="blob-code blob-code-inner js-file-line">		<span class="pl-k">+</span> <span class="pl-k">case</span> <span class="pl-k">when</span> <span class="pl-c1">obj</span>.<span class="pl-c1">name</span> COLLATE database_default <span class="pl-k">is</span> <span class="pl-k">not</span> <span class="pl-k">null</span> <span class="pl-k">THEN</span> <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">N</span><span class="pl-pds">&#39;</span> ON &#39;</span> <span class="pl-k">+</span> <span class="pl-c1">sc</span>.<span class="pl-c1">class_desc</span> <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>::&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">ISNULL</span>(<span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">s</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>.&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>&#39;</span>) <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">obj</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">ELSE</span> <span class="pl-s"><span class="pl-pds">&#39;</span>&#39;</span> <span class="pl-k">END</span> </td>
        </tr>
        <tr>
          <td id="L43" class="blob-num js-line-number" data-line-number="43"></td>
          <td id="LC43" class="blob-code blob-code-inner js-file-line">		<span class="pl-k">+</span> <span class="pl-k">CASE</span> <span class="pl-k">WHEN</span> <span class="pl-c1">cl</span>.<span class="pl-c1">column_id</span> <span class="pl-k">IS</span> <span class="pl-k">NULL</span> <span class="pl-k">THEN</span> <span class="pl-s"><span class="pl-pds">&#39;</span> &#39;</span> <span class="pl-k">ELSE</span> <span class="pl-s"><span class="pl-pds">&#39;</span>(&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">cl</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>)&#39;</span> <span class="pl-k">END</span> </td>
        </tr>
        <tr>
          <td id="L44" class="blob-num js-line-number" data-line-number="44"></td>
          <td id="LC44" class="blob-code blob-code-inner js-file-line">		<span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">N</span><span class="pl-pds">&#39;</span> TO &#39;</span> <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">u</span>.<span class="pl-c1">name</span> COLLATE database_default)</td>
        </tr>
        <tr>
          <td id="L45" class="blob-num js-line-number" data-line-number="45"></td>
          <td id="LC45" class="blob-code blob-code-inner js-file-line">	,	Revoke_TSQL <span class="pl-k">=</span> <span class="pl-s"><span class="pl-pds">N</span><span class="pl-pds">&#39;</span>REVOKE &#39;</span> <span class="pl-k">+</span> <span class="pl-c1">perm</span>.<span class="pl-c1">permission_name</span> </td>
        </tr>
        <tr>
          <td id="L46" class="blob-num js-line-number" data-line-number="46"></td>
          <td id="LC46" class="blob-code blob-code-inner js-file-line">		<span class="pl-k">+</span> <span class="pl-k">case</span> <span class="pl-k">when</span> <span class="pl-c1">obj</span>.<span class="pl-c1">name</span> COLLATE database_default <span class="pl-k">is</span> <span class="pl-k">not</span> <span class="pl-k">null</span> <span class="pl-k">THEN</span> <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">N</span><span class="pl-pds">&#39;</span> ON &#39;</span> <span class="pl-k">+</span> <span class="pl-c1">sc</span>.<span class="pl-c1">class_desc</span> <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>::&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">ISNULL</span>(<span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">s</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>.&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>&#39;</span>) <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">obj</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">ELSE</span> <span class="pl-s"><span class="pl-pds">&#39;</span>&#39;</span> <span class="pl-k">END</span> </td>
        </tr>
        <tr>
          <td id="L47" class="blob-num js-line-number" data-line-number="47"></td>
          <td id="LC47" class="blob-code blob-code-inner js-file-line">		<span class="pl-k">+</span> <span class="pl-k">CASE</span> <span class="pl-k">WHEN</span> <span class="pl-c1">cl</span>.<span class="pl-c1">column_id</span> <span class="pl-k">IS</span> <span class="pl-k">NULL</span> <span class="pl-k">THEN</span> <span class="pl-s"><span class="pl-pds">&#39;</span> &#39;</span> <span class="pl-k">ELSE</span> <span class="pl-s"><span class="pl-pds">&#39;</span>(&#39;</span> <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">cl</span>.<span class="pl-c1">name</span> COLLATE database_default) <span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">&#39;</span>)&#39;</span> <span class="pl-k">END</span> </td>
        </tr>
        <tr>
          <td id="L48" class="blob-num js-line-number" data-line-number="48"></td>
          <td id="LC48" class="blob-code blob-code-inner js-file-line">		<span class="pl-k">+</span> <span class="pl-s"><span class="pl-pds">N</span><span class="pl-pds">&#39;</span> TO &#39;</span> <span class="pl-k">+</span> <span class="pl-c1">QUOTENAME</span>(<span class="pl-c1">u</span>.<span class="pl-c1">name</span> COLLATE database_default) </td>
        </tr>
        <tr>
          <td id="L49" class="blob-num js-line-number" data-line-number="49"></td>
          <td id="LC49" class="blob-code blob-code-inner js-file-line">		, <span class="pl-k">*</span></td>
        </tr>
        <tr>
          <td id="L50" class="blob-num js-line-number" data-line-number="50"></td>
          <td id="LC50" class="blob-code blob-code-inner js-file-line"><span class="pl-k">FROM</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_permissions</span> <span class="pl-k">AS</span> perm </td>
        </tr>
        <tr>
          <td id="L51" class="blob-num js-line-number" data-line-number="51"></td>
          <td id="LC51" class="blob-code blob-code-inner js-file-line"><span class="pl-k">INNER JOIN</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_principals</span> <span class="pl-k">AS</span> u	<span class="pl-k">ON</span> <span class="pl-c1">perm</span>.<span class="pl-c1">grantee_principal_id</span> <span class="pl-k">=</span> <span class="pl-c1">u</span>.<span class="pl-c1">principal_id</span></td>
        </tr>
        <tr>
          <td id="L52" class="blob-num js-line-number" data-line-number="52"></td>
          <td id="LC52" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L53" class="blob-num js-line-number" data-line-number="53"></td>
          <td id="LC53" class="blob-code blob-code-inner js-file-line"><span class="pl-k">LEFT OUTER JOIN</span> (<span class="pl-c"><span class="pl-c">--</span>https://msdn.microsoft.com/en-us/library/ms188367.aspx			</span></td>
        </tr>
        <tr>
          <td id="L54" class="blob-num js-line-number" data-line-number="54"></td>
          <td id="LC54" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, <span class="pl-c1">object_id</span>, <span class="pl-c1">schema_id</span>, is_ms_shipped, class_desc<span class="pl-k">=</span><span class="pl-s"><span class="pl-pds">&#39;</span>OBJECT&#39;</span>, <span class="pl-k">type_desc</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">objects</span> </td>
        </tr>
        <tr>
          <td id="L55" class="blob-num js-line-number" data-line-number="55"></td>
          <td id="LC55" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L56" class="blob-num js-line-number" data-line-number="56"></td>
          <td id="LC56" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, <span class="pl-c1">0</span>, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>DATABASE&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>DATABASE&#39;</span>  <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">databases</span> 	</td>
        </tr>
        <tr>
          <td id="L57" class="blob-num js-line-number" data-line-number="57"></td>
          <td id="LC57" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L58" class="blob-num js-line-number" data-line-number="58"></td>
          <td id="LC58" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span>  <span class="pl-k">name</span>, <span class="pl-c1">schema_id</span>, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>SCHEMA&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>SCHEMA&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">schemas</span></td>
        </tr>
        <tr>
          <td id="L59" class="blob-num js-line-number" data-line-number="59"></td>
          <td id="LC59" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L60" class="blob-num js-line-number" data-line-number="60"></td>
          <td id="LC60" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, principal_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>,  <span class="pl-s"><span class="pl-pds">&#39;</span>USER&#39;</span>, <span class="pl-k">type_desc</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_principals</span> <span class="pl-k">where</span> <span class="pl-k">type_desc</span> <span class="pl-k">in</span> (<span class="pl-s"><span class="pl-pds">&#39;</span>WINDOWS_USER&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>SQL_USER&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>ASYMMETRIC_KEY_MAPPED_USER&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>CERTIFICATE_MAPPED_USER&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>WINDOWS_GROUP&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>EXTERNAL_GROUPS&#39;</span>)</td>
        </tr>
        <tr>
          <td id="L61" class="blob-num js-line-number" data-line-number="61"></td>
          <td id="LC61" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L62" class="blob-num js-line-number" data-line-number="62"></td>
          <td id="LC62" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, principal_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>,  <span class="pl-s"><span class="pl-pds">&#39;</span>USER&#39;</span>, <span class="pl-k">type_desc</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_principals</span> <span class="pl-k">where</span> <span class="pl-k">type_desc</span> <span class="pl-k">in</span> (<span class="pl-s"><span class="pl-pds">&#39;</span>WINDOWS_USER&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>SQL_USER&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>ASYMMETRIC_KEY_MAPPED_USER&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>CERTIFICATE_MAPPED_USER&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>WINDOWS_GROUP&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>EXTERNAL_GROUPS&#39;</span>)</td>
        </tr>
        <tr>
          <td id="L63" class="blob-num js-line-number" data-line-number="63"></td>
          <td id="LC63" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L64" class="blob-num js-line-number" data-line-number="64"></td>
          <td id="LC64" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, principal_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>APPLICATION ROLE&#39;</span>, <span class="pl-k">type_desc</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_principals</span> <span class="pl-k">where</span> <span class="pl-k">type_desc</span> <span class="pl-k">in</span> (<span class="pl-s"><span class="pl-pds">&#39;</span>APPLICATION_ROLE&#39;</span>)</td>
        </tr>
        <tr>
          <td id="L65" class="blob-num js-line-number" data-line-number="65"></td>
          <td id="LC65" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L66" class="blob-num js-line-number" data-line-number="66"></td>
          <td id="LC66" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, principal_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>ROLE&#39;</span>, <span class="pl-k">type_desc</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">database_principals</span> <span class="pl-k">where</span> <span class="pl-k">type_desc</span> <span class="pl-k">in</span> (<span class="pl-s"><span class="pl-pds">&#39;</span>DATABASE_ROLE&#39;</span>)</td>
        </tr>
        <tr>
          <td id="L67" class="blob-num js-line-number" data-line-number="67"></td>
          <td id="LC67" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L68" class="blob-num js-line-number" data-line-number="68"></td>
          <td id="LC68" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, assembly_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>ASSEMBLY&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>ASSEMBLY&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">assemblies</span> </td>
        </tr>
        <tr>
          <td id="L69" class="blob-num js-line-number" data-line-number="69"></td>
          <td id="LC69" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L70" class="blob-num js-line-number" data-line-number="70"></td>
          <td id="LC70" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, user_type_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>TYPE&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>USER TYPE&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">types</span> </td>
        </tr>
        <tr>
          <td id="L71" class="blob-num js-line-number" data-line-number="71"></td>
          <td id="LC71" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L72" class="blob-num js-line-number" data-line-number="72"></td>
          <td id="LC72" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, xml_collection_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>XML SCHEMA COLLECTION&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>XML SCHEMA COLLECTION&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">xml_schema_collections</span></td>
        </tr>
        <tr>
          <td id="L73" class="blob-num js-line-number" data-line-number="73"></td>
          <td id="LC73" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L74" class="blob-num js-line-number" data-line-number="74"></td>
          <td id="LC74" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span> COLLATE database_default, message_type_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>MESSAGE TYPE&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>MESSAGE TYPE&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">service_message_types</span></td>
        </tr>
        <tr>
          <td id="L75" class="blob-num js-line-number" data-line-number="75"></td>
          <td id="LC75" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L76" class="blob-num js-line-number" data-line-number="76"></td>
          <td id="LC76" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span> COLLATE database_default, service_contract_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>CONTRACT&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>CONTRACT&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">service_contracts</span></td>
        </tr>
        <tr>
          <td id="L77" class="blob-num js-line-number" data-line-number="77"></td>
          <td id="LC77" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L78" class="blob-num js-line-number" data-line-number="78"></td>
          <td id="LC78" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span> COLLATE database_default, service_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>SERVICE&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>SERVICE&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">services</span></td>
        </tr>
        <tr>
          <td id="L79" class="blob-num js-line-number" data-line-number="79"></td>
          <td id="LC79" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L80" class="blob-num js-line-number" data-line-number="80"></td>
          <td id="LC80" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span> COLLATE database_default, remote_service_binding_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>REMOTE SERVICE BINDING&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>REMOTE SERVICE BINDING&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">remote_service_bindings</span></td>
        </tr>
        <tr>
          <td id="L81" class="blob-num js-line-number" data-line-number="81"></td>
          <td id="LC81" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L82" class="blob-num js-line-number" data-line-number="82"></td>
          <td id="LC82" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span> COLLATE database_default, route_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>ROUTE&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>ROUTE&#39;</span>  <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">routes</span></td>
        </tr>
        <tr>
          <td id="L83" class="blob-num js-line-number" data-line-number="83"></td>
          <td id="LC83" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L84" class="blob-num js-line-number" data-line-number="84"></td>
          <td id="LC84" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span> COLLATE database_default, fulltext_catalog_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>FULLTEXT CATALOG&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>FULLTEXT CATALOG&#39;</span>  <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">fulltext_catalogs</span></td>
        </tr>
        <tr>
          <td id="L85" class="blob-num js-line-number" data-line-number="85"></td>
          <td id="LC85" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L86" class="blob-num js-line-number" data-line-number="86"></td>
          <td id="LC86" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, symmetric_key_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>SYMMETRIC KEY&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>SYMMETRIC KEY&#39;</span>  <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">symmetric_keys</span></td>
        </tr>
        <tr>
          <td id="L87" class="blob-num js-line-number" data-line-number="87"></td>
          <td id="LC87" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L88" class="blob-num js-line-number" data-line-number="88"></td>
          <td id="LC88" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, certificate_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>CERTIFICATE&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>CERTIFICATE&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">certificates</span></td>
        </tr>
        <tr>
          <td id="L89" class="blob-num js-line-number" data-line-number="89"></td>
          <td id="LC89" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">union all</span></td>
        </tr>
        <tr>
          <td id="L90" class="blob-num js-line-number" data-line-number="90"></td>
          <td id="LC90" class="blob-code blob-code-inner js-file-line">					<span class="pl-k">select</span> <span class="pl-k">name</span>, asymmetric_key_id, <span class="pl-k">null</span>, <span class="pl-k">null</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>ASYMMETRIC KEY&#39;</span>, <span class="pl-s"><span class="pl-pds">&#39;</span>ASYMMETRIC KEY&#39;</span> <span class="pl-k">from</span> <span class="pl-c1">sys</span>.<span class="pl-c1">asymmetric_keys</span></td>
        </tr>
        <tr>
          <td id="L91" class="blob-num js-line-number" data-line-number="91"></td>
          <td id="LC91" class="blob-code blob-code-inner js-file-line">			) obj</td>
        </tr>
        <tr>
          <td id="L92" class="blob-num js-line-number" data-line-number="92"></td>
          <td id="LC92" class="blob-code blob-code-inner js-file-line"><span class="pl-k">ON</span> <span class="pl-c1">perm</span>.<span class="pl-c1">major_id</span> <span class="pl-k">=</span> obj.[object_id] </td>
        </tr>
        <tr>
          <td id="L93" class="blob-num js-line-number" data-line-number="93"></td>
          <td id="LC93" class="blob-code blob-code-inner js-file-line"><span class="pl-k">INNER JOIN</span> <span class="pl-c1">sys</span>.<span class="pl-c1">securable_classes</span> sc <span class="pl-k">on</span> <span class="pl-c1">sc</span>.<span class="pl-c1">class</span> <span class="pl-k">=</span> <span class="pl-c1">perm</span>.<span class="pl-c1">class</span> </td>
        </tr>
        <tr>
          <td id="L94" class="blob-num js-line-number" data-line-number="94"></td>
          <td id="LC94" class="blob-code blob-code-inner js-file-line"><span class="pl-k">and</span> <span class="pl-c1">sc</span>.<span class="pl-c1">class_desc</span> <span class="pl-k">=</span> <span class="pl-c1">obj</span>.<span class="pl-c1">class_desc</span></td>
        </tr>
        <tr>
          <td id="L95" class="blob-num js-line-number" data-line-number="95"></td>
          <td id="LC95" class="blob-code blob-code-inner js-file-line"><span class="pl-k">LEFT OUTER JOIN</span> <span class="pl-c1">sys</span>.<span class="pl-c1">schemas</span> s <span class="pl-k">ON</span> <span class="pl-c1">s</span>.<span class="pl-c1">schema_id</span> <span class="pl-k">=</span> <span class="pl-c1">obj</span>.<span class="pl-c1">schema_id</span></td>
        </tr>
        <tr>
          <td id="L96" class="blob-num js-line-number" data-line-number="96"></td>
          <td id="LC96" class="blob-code blob-code-inner js-file-line"><span class="pl-k">LEFT OUTER JOIN</span> <span class="pl-c1">sys</span>.<span class="pl-c1">columns</span> cl <span class="pl-k">ON</span> <span class="pl-c1">cl</span>.<span class="pl-c1">column_id</span> <span class="pl-k">=</span> <span class="pl-c1">perm</span>.<span class="pl-c1">minor_id</span> <span class="pl-k">AND</span> cl.[object_id] <span class="pl-k">=</span> <span class="pl-c1">perm</span>.<span class="pl-c1">major_id</span></td>
        </tr>
        <tr>
          <td id="L97" class="blob-num js-line-number" data-line-number="97"></td>
          <td id="LC97" class="blob-code blob-code-inner js-file-line"><span class="pl-k">where</span> <span class="pl-c1">1</span><span class="pl-k">=</span><span class="pl-c1">1</span></td>
        </tr>
        <tr>
          <td id="L98" class="blob-num js-line-number" data-line-number="98"></td>
          <td id="LC98" class="blob-code blob-code-inner js-file-line"><span class="pl-k">and</span> <span class="pl-c1">perm</span>.<span class="pl-c1">major_id</span> <span class="pl-k">&gt;</span> <span class="pl-c1">0</span></td>
        </tr>
        <tr>
          <td id="L99" class="blob-num js-line-number" data-line-number="99"></td>
          <td id="LC99" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Ignore internal principals</span></td>
        </tr>
        <tr>
          <td id="L100" class="blob-num js-line-number" data-line-number="100"></td>
          <td id="LC100" class="blob-code blob-code-inner js-file-line"><span class="pl-k">and</span> <span class="pl-c1">u</span>.<span class="pl-c1">name</span> COLLATE database_default <span class="pl-k">not</span> <span class="pl-k">in</span> (<span class="pl-s"><span class="pl-pds">&#39;</span>dbo&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>guest&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>INFORMATION_SCHEMA&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>sys&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>MS_DataCollectorInternalUser&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>PolicyAdministratorRole&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>ServerGroupReaderRole&#39;</span></td>
        </tr>
        <tr>
          <td id="L101" class="blob-num js-line-number" data-line-number="101"></td>
          <td id="LC101" class="blob-code blob-code-inner js-file-line">,<span class="pl-s"><span class="pl-pds">&#39;</span>ServerGroupAdministratorRole&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>TargetServersRole&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>SQLAgentUserRole&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>UtilityCMRReader&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>SQLAgentOperatorRole&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>dc_operator&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>dc_proxy&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>dc_admin&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>db_ssisadmin&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>db_ssisltduser&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>db_ssisoperator&#39;</span></td>
        </tr>
        <tr>
          <td id="L102" class="blob-num js-line-number" data-line-number="102"></td>
          <td id="LC102" class="blob-code blob-code-inner js-file-line">,<span class="pl-s"><span class="pl-pds">&#39;</span>UtilityIMRWriter&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>UtilityIMRReader&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>RSExecRole&#39;</span>,<span class="pl-s"><span class="pl-pds">&#39;</span>DatabaseMailUserRole&#39;</span>)</td>
        </tr>
        <tr>
          <td id="L103" class="blob-num js-line-number" data-line-number="103"></td>
          <td id="LC103" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Ignore ## principals</span></td>
        </tr>
        <tr>
          <td id="L104" class="blob-num js-line-number" data-line-number="104"></td>
          <td id="LC104" class="blob-code blob-code-inner js-file-line"><span class="pl-k">and</span> <span class="pl-c1">u</span>.<span class="pl-c1">name</span> COLLATE database_default <span class="pl-k">not</span> <span class="pl-k">like</span> <span class="pl-s"><span class="pl-pds">&#39;</span>##%##&#39;</span></td>
        </tr>
        <tr>
          <td id="L105" class="blob-num js-line-number" data-line-number="105"></td>
          <td id="LC105" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Ignore built-in svc accounts (not recommended anyway!)</span></td>
        </tr>
        <tr>
          <td id="L106" class="blob-num js-line-number" data-line-number="106"></td>
          <td id="LC106" class="blob-code blob-code-inner js-file-line"><span class="pl-k">and</span> <span class="pl-c1">u</span>.<span class="pl-c1">name</span> COLLATE database_default <span class="pl-k">not</span> <span class="pl-k">like</span> <span class="pl-s"><span class="pl-pds">&#39;</span>NT SERVICE%&#39;</span></td>
        </tr>
        <tr>
          <td id="L107" class="blob-num js-line-number" data-line-number="107"></td>
          <td id="LC107" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Ignore MS shipped internal objects </span></td>
        </tr>
        <tr>
          <td id="L108" class="blob-num js-line-number" data-line-number="108"></td>
          <td id="LC108" class="blob-code blob-code-inner js-file-line"><span class="pl-k">and</span> (<span class="pl-c1">obj</span>.<span class="pl-c1">is_ms_shipped</span> <span class="pl-k">=</span> <span class="pl-c1">0</span> <span class="pl-k">or</span> <span class="pl-c1">obj</span>.<span class="pl-c1">is_ms_shipped</span> <span class="pl-k">is</span> <span class="pl-k">null</span>) </td>
        </tr>
        <tr>
          <td id="L109" class="blob-num js-line-number" data-line-number="109"></td>
          <td id="LC109" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>Ignore system sprocs (be aware of your naming conventions!)</span></td>
        </tr>
        <tr>
          <td id="L110" class="blob-num js-line-number" data-line-number="110"></td>
          <td id="LC110" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">--</span>and (obj.name not like &#39;sp_%&#39; or obj.name is null)</span></td>
        </tr>
        <tr>
          <td id="L111" class="blob-num js-line-number" data-line-number="111"></td>
          <td id="LC111" class="blob-code blob-code-inner js-file-line"><span class="pl-k">order by</span> Object_Type_Desc, Principal_Name</td>
        </tr>
        <tr>
          <td id="L112" class="blob-num js-line-number" data-line-number="112"></td>
          <td id="LC112" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L113" class="blob-num js-line-number" data-line-number="113"></td>
          <td id="LC113" class="blob-code blob-code-inner js-file-line">
  </td>
        </tr>
        <tr>
          <td id="L114" class="blob-num js-line-number" data-line-number="114"></td>
          <td id="LC114" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">/*</span></span></td>
        </tr>
        <tr>
          <td id="L115" class="blob-num js-line-number" data-line-number="115"></td>
          <td id="LC115" class="blob-code blob-code-inner js-file-line"><span class="pl-c">--Multi-database database permissions</span></td>
        </tr>
        <tr>
          <td id="L116" class="blob-num js-line-number" data-line-number="116"></td>
          <td id="LC116" class="blob-code blob-code-inner js-file-line"><span class="pl-c">--script is too long for sp_msforeachdb, had to roll our own.</span></td>
        </tr>
        <tr>
          <td id="L117" class="blob-num js-line-number" data-line-number="117"></td>
          <td id="LC117" class="blob-code blob-code-inner js-file-line"><span class="pl-c"></span></td>
        </tr>
        <tr>
          <td id="L118" class="blob-num js-line-number" data-line-number="118"></td>
          <td id="LC118" class="blob-code blob-code-inner js-file-line"><span class="pl-c">declare @tsql varchar(8000) = null, @dbcount int = 0, @x int = 0, @dbname varchar(256) = null</span></td>
        </tr>
        <tr>
          <td id="L119" class="blob-num js-line-number" data-line-number="119"></td>
          <td id="LC119" class="blob-code blob-code-inner js-file-line"><span class="pl-c">declare @dblist table (id int not null identity(1,1) primary key, dbname varchar(256)  not null )</span></td>
        </tr>
        <tr>
          <td id="L120" class="blob-num js-line-number" data-line-number="120"></td>
          <td id="LC120" class="blob-code blob-code-inner js-file-line"><span class="pl-c">insert into @dblist (dbname)</span></td>
        </tr>
        <tr>
          <td id="L121" class="blob-num js-line-number" data-line-number="121"></td>
          <td id="LC121" class="blob-code blob-code-inner js-file-line"><span class="pl-c">select name from sys.databases where name &lt;&gt; &#39;tempdb&#39; and state_desc = &#39;ONLINE&#39; </span></td>
        </tr>
        <tr>
          <td id="L122" class="blob-num js-line-number" data-line-number="122"></td>
          <td id="LC122" class="blob-code blob-code-inner js-file-line"><span class="pl-c">order by database_id</span></td>
        </tr>
        <tr>
          <td id="L123" class="blob-num js-line-number" data-line-number="123"></td>
          <td id="LC123" class="blob-code blob-code-inner js-file-line"><span class="pl-c">select @dbcount = count(dbname) from @dblist</span></td>
        </tr>
        <tr>
          <td id="L124" class="blob-num js-line-number" data-line-number="124"></td>
          <td id="LC124" class="blob-code blob-code-inner js-file-line"><span class="pl-c"></span></td>
        </tr>
        <tr>
          <td id="L125" class="blob-num js-line-number" data-line-number="125"></td>
          <td id="LC125" class="blob-code blob-code-inner js-file-line"><span class="pl-c">while (@x &lt;= @dbcount)</span></td>
        </tr>
        <tr>
          <td id="L126" class="blob-num js-line-number" data-line-number="126"></td>
          <td id="LC126" class="blob-code blob-code-inner js-file-line"><span class="pl-c">BEGIN</span></td>
        </tr>
        <tr>
          <td id="L127" class="blob-num js-line-number" data-line-number="127"></td>
          <td id="LC127" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	select @dbname = dbname from @dblist d where @x = d.id;</span></td>
        </tr>
        <tr>
          <td id="L128" class="blob-num js-line-number" data-line-number="128"></td>
          <td id="LC128" class="blob-code blob-code-inner js-file-line"><span class="pl-c"></span></td>
        </tr>
        <tr>
          <td id="L129" class="blob-num js-line-number" data-line-number="129"></td>
          <td id="LC129" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	select @tsql = 	&#39;USE [&#39; + @dbname  + &#39;];</span></td>
        </tr>
        <tr>
          <td id="L130" class="blob-num js-line-number" data-line-number="130"></td>
          <td id="LC130" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	SELECT DB_NAME();</span></td>
        </tr>
        <tr>
          <td id="L131" class="blob-num js-line-number" data-line-number="131"></td>
          <td id="LC131" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	SELECT	Permission_State_Desc	=	perm.state_desc</span></td>
        </tr>
        <tr>
          <td id="L132" class="blob-num js-line-number" data-line-number="132"></td>
          <td id="LC132" class="blob-code blob-code-inner js-file-line"><span class="pl-c">		,	Permission_Name			=	perm.permission_name </span></td>
        </tr>
        <tr>
          <td id="L133" class="blob-num js-line-number" data-line-number="133"></td>
          <td id="LC133" class="blob-code blob-code-inner js-file-line"><span class="pl-c">		,	Permission_Object_Name	= ISNULL(QUOTENAME(s.name ) + &#39;&#39;.&#39;&#39;,&#39;&#39;&#39;&#39;) + QUOTENAME(obj.name COLLATE database_default) + CASE WHEN cl.name COLLATE database_default is null THEN &#39;&#39;&#39;&#39; ELSE &#39;&#39;.&#39;&#39; + QUOTENAME(cl.name COLLATE database_default) END 			</span></td>
        </tr>
        <tr>
          <td id="L134" class="blob-num js-line-number" data-line-number="134"></td>
          <td id="LC134" class="blob-code blob-code-inner js-file-line"><span class="pl-c">		,	Object_Type_Desc		=	obj.type_desc   </span></td>
        </tr>
        <tr>
          <td id="L135" class="blob-num js-line-number" data-line-number="135"></td>
          <td id="LC135" class="blob-code blob-code-inner js-file-line"><span class="pl-c">		,	Principal_Name			=	QUOTENAME(u.name COLLATE database_default) </span></td>
        </tr>
        <tr>
          <td id="L136" class="blob-num js-line-number" data-line-number="136"></td>
          <td id="LC136" class="blob-code blob-code-inner js-file-line"><span class="pl-c">		,	User_Type				=	u.type_desc </span></td>
        </tr>
        <tr>
          <td id="L137" class="blob-num js-line-number" data-line-number="137"></td>
          <td id="LC137" class="blob-code blob-code-inner js-file-line"><span class="pl-c">		,	Create_TSQL = perm.state_desc + N&#39;&#39; &#39;&#39; + perm.permission_name </span></td>
        </tr>
        <tr>
          <td id="L138" class="blob-num js-line-number" data-line-number="138"></td>
          <td id="LC138" class="blob-code blob-code-inner js-file-line"><span class="pl-c">			+ case when obj.name COLLATE database_default is not null THEN + N&#39;&#39; ON &#39;&#39; + sc.class_desc + &#39;&#39;::&#39;&#39; + ISNULL(QUOTENAME(s.name COLLATE database_default) + &#39;&#39;.&#39;&#39;,&#39;&#39;&#39;&#39;) + QUOTENAME(obj.name COLLATE database_default) ELSE &#39;&#39;&#39;&#39; END </span></td>
        </tr>
        <tr>
          <td id="L139" class="blob-num js-line-number" data-line-number="139"></td>
          <td id="LC139" class="blob-code blob-code-inner js-file-line"><span class="pl-c">			+ CASE WHEN cl.column_id IS NULL THEN &#39;&#39; &#39;&#39; ELSE &#39;&#39;(&#39;&#39; + QUOTENAME(cl.name COLLATE database_default) + &#39;&#39;)&#39;&#39; END </span></td>
        </tr>
        <tr>
          <td id="L140" class="blob-num js-line-number" data-line-number="140"></td>
          <td id="LC140" class="blob-code blob-code-inner js-file-line"><span class="pl-c">			+ N&#39;&#39; TO &#39;&#39; + QUOTENAME(u.name COLLATE database_default)</span></td>
        </tr>
        <tr>
          <td id="L141" class="blob-num js-line-number" data-line-number="141"></td>
          <td id="LC141" class="blob-code blob-code-inner js-file-line"><span class="pl-c">		,	Revoke_TSQL = N&#39;&#39;REVOKE &#39;&#39; + perm.permission_name </span></td>
        </tr>
        <tr>
          <td id="L142" class="blob-num js-line-number" data-line-number="142"></td>
          <td id="LC142" class="blob-code blob-code-inner js-file-line"><span class="pl-c">			+ case when obj.name COLLATE database_default is not null THEN + N&#39;&#39; ON &#39;&#39; + sc.class_desc + &#39;&#39;::&#39;&#39; + ISNULL(QUOTENAME(s.name COLLATE database_default) + &#39;&#39;.&#39;&#39;,&#39;&#39;&#39;&#39;) + QUOTENAME(obj.name COLLATE database_default) ELSE &#39;&#39;&#39;&#39; END </span></td>
        </tr>
        <tr>
          <td id="L143" class="blob-num js-line-number" data-line-number="143"></td>
          <td id="LC143" class="blob-code blob-code-inner js-file-line"><span class="pl-c">			+ CASE WHEN cl.column_id IS NULL THEN &#39;&#39; &#39;&#39; ELSE &#39;&#39;(&#39;&#39; + QUOTENAME(cl.name COLLATE database_default) + &#39;&#39;)&#39;&#39; END </span></td>
        </tr>
        <tr>
          <td id="L144" class="blob-num js-line-number" data-line-number="144"></td>
          <td id="LC144" class="blob-code blob-code-inner js-file-line"><span class="pl-c">			+ N&#39;&#39; TO &#39;&#39; + QUOTENAME(u.name COLLATE database_default) </span></td>
        </tr>
        <tr>
          <td id="L145" class="blob-num js-line-number" data-line-number="145"></td>
          <td id="LC145" class="blob-code blob-code-inner js-file-line"><span class="pl-c">			, *</span></td>
        </tr>
        <tr>
          <td id="L146" class="blob-num js-line-number" data-line-number="146"></td>
          <td id="LC146" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	FROM sys.database_permissions AS perm </span></td>
        </tr>
        <tr>
          <td id="L147" class="blob-num js-line-number" data-line-number="147"></td>
          <td id="LC147" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	INNER JOIN sys.database_principals AS u	ON perm.grantee_principal_id = u.principal_id</span></td>
        </tr>
        <tr>
          <td id="L148" class="blob-num js-line-number" data-line-number="148"></td>
          <td id="LC148" class="blob-code blob-code-inner js-file-line"><span class="pl-c"></span></td>
        </tr>
        <tr>
          <td id="L149" class="blob-num js-line-number" data-line-number="149"></td>
          <td id="LC149" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	LEFT OUTER JOIN (--https://msdn.microsoft.com/en-us/library/ms188367.aspx			</span></td>
        </tr>
        <tr>
          <td id="L150" class="blob-num js-line-number" data-line-number="150"></td>
          <td id="LC150" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, object_id, schema_id, is_ms_shipped, class_desc=&#39;&#39;OBJECT&#39;&#39;, type_desc from sys.objects </span></td>
        </tr>
        <tr>
          <td id="L151" class="blob-num js-line-number" data-line-number="151"></td>
          <td id="LC151" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L152" class="blob-num js-line-number" data-line-number="152"></td>
          <td id="LC152" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, 0, null, null, &#39;&#39;DATABASE&#39;&#39;, &#39;&#39;DATABASE&#39;&#39;  from sys.databases 	</span></td>
        </tr>
        <tr>
          <td id="L153" class="blob-num js-line-number" data-line-number="153"></td>
          <td id="LC153" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L154" class="blob-num js-line-number" data-line-number="154"></td>
          <td id="LC154" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select  name, schema_id, null, null, &#39;&#39;SCHEMA&#39;&#39;, &#39;&#39;SCHEMA&#39;&#39; from sys.schemas</span></td>
        </tr>
        <tr>
          <td id="L155" class="blob-num js-line-number" data-line-number="155"></td>
          <td id="LC155" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L156" class="blob-num js-line-number" data-line-number="156"></td>
          <td id="LC156" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, principal_id, null, null,  &#39;&#39;USER&#39;&#39;, type_desc from sys.database_principals where type_desc in (&#39;&#39;WINDOWS_USER&#39;&#39;,&#39;&#39;SQL_USER&#39;&#39;,&#39;&#39;ASYMMETRIC_KEY_MAPPED_USER&#39;&#39;,&#39;&#39;CERTIFICATE_MAPPED_USER&#39;&#39;, &#39;&#39;WINDOWS_GROUP&#39;&#39;,&#39;&#39;EXTERNAL_GROUPS&#39;&#39;)</span></td>
        </tr>
        <tr>
          <td id="L157" class="blob-num js-line-number" data-line-number="157"></td>
          <td id="LC157" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L158" class="blob-num js-line-number" data-line-number="158"></td>
          <td id="LC158" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, principal_id, null, null,  &#39;&#39;USER&#39;&#39;, type_desc from sys.database_principals where type_desc in (&#39;&#39;WINDOWS_USER&#39;&#39;,&#39;&#39;SQL_USER&#39;&#39;,&#39;&#39;ASYMMETRIC_KEY_MAPPED_USER&#39;&#39;,&#39;&#39;CERTIFICATE_MAPPED_USER&#39;&#39;, &#39;&#39;WINDOWS_GROUP&#39;&#39;,&#39;&#39;EXTERNAL_GROUPS&#39;&#39;)</span></td>
        </tr>
        <tr>
          <td id="L159" class="blob-num js-line-number" data-line-number="159"></td>
          <td id="LC159" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L160" class="blob-num js-line-number" data-line-number="160"></td>
          <td id="LC160" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, principal_id, null, null, &#39;&#39;APPLICATION ROLE&#39;&#39;, type_desc from sys.database_principals where type_desc in (&#39;&#39;APPLICATION_ROLE&#39;&#39;)</span></td>
        </tr>
        <tr>
          <td id="L161" class="blob-num js-line-number" data-line-number="161"></td>
          <td id="LC161" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L162" class="blob-num js-line-number" data-line-number="162"></td>
          <td id="LC162" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, principal_id, null, null, &#39;&#39;ROLE&#39;&#39;, type_desc from sys.database_principals where type_desc in (&#39;&#39;DATABASE_ROLE&#39;&#39;)</span></td>
        </tr>
        <tr>
          <td id="L163" class="blob-num js-line-number" data-line-number="163"></td>
          <td id="LC163" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L164" class="blob-num js-line-number" data-line-number="164"></td>
          <td id="LC164" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, assembly_id, null, null, &#39;&#39;ASSEMBLY&#39;&#39;, &#39;&#39;ASSEMBLY&#39;&#39; from sys.assemblies </span></td>
        </tr>
        <tr>
          <td id="L165" class="blob-num js-line-number" data-line-number="165"></td>
          <td id="LC165" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L166" class="blob-num js-line-number" data-line-number="166"></td>
          <td id="LC166" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, user_type_id, null, null, &#39;&#39;TYPE&#39;&#39;, &#39;&#39;USER TYPE&#39;&#39; from sys.types </span></td>
        </tr>
        <tr>
          <td id="L167" class="blob-num js-line-number" data-line-number="167"></td>
          <td id="LC167" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L168" class="blob-num js-line-number" data-line-number="168"></td>
          <td id="LC168" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, xml_collection_id, null, null, &#39;&#39;XML SCHEMA COLLECTION&#39;&#39;, &#39;&#39;XML SCHEMA COLLECTION&#39;&#39; from sys.xml_schema_collections</span></td>
        </tr>
        <tr>
          <td id="L169" class="blob-num js-line-number" data-line-number="169"></td>
          <td id="LC169" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L170" class="blob-num js-line-number" data-line-number="170"></td>
          <td id="LC170" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name COLLATE database_default, message_type_id, null, null, &#39;&#39;MESSAGE TYPE&#39;&#39;, &#39;&#39;MESSAGE TYPE&#39;&#39; from sys.service_message_types</span></td>
        </tr>
        <tr>
          <td id="L171" class="blob-num js-line-number" data-line-number="171"></td>
          <td id="LC171" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L172" class="blob-num js-line-number" data-line-number="172"></td>
          <td id="LC172" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name COLLATE database_default, service_contract_id, null, null, &#39;&#39;CONTRACT&#39;&#39;, &#39;&#39;CONTRACT&#39;&#39; from sys.service_contracts</span></td>
        </tr>
        <tr>
          <td id="L173" class="blob-num js-line-number" data-line-number="173"></td>
          <td id="LC173" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L174" class="blob-num js-line-number" data-line-number="174"></td>
          <td id="LC174" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name COLLATE database_default, service_id, null, null, &#39;&#39;SERVICE&#39;&#39;, &#39;&#39;SERVICE&#39;&#39; from sys.services</span></td>
        </tr>
        <tr>
          <td id="L175" class="blob-num js-line-number" data-line-number="175"></td>
          <td id="LC175" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L176" class="blob-num js-line-number" data-line-number="176"></td>
          <td id="LC176" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name COLLATE database_default, remote_service_binding_id, null, null, &#39;&#39;REMOTE SERVICE BINDING&#39;&#39;, &#39;&#39;REMOTE SERVICE BINDING&#39;&#39; from sys.remote_service_bindings</span></td>
        </tr>
        <tr>
          <td id="L177" class="blob-num js-line-number" data-line-number="177"></td>
          <td id="LC177" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L178" class="blob-num js-line-number" data-line-number="178"></td>
          <td id="LC178" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name COLLATE database_default, route_id, null, null, &#39;&#39;ROUTE&#39;&#39;, &#39;&#39;ROUTE&#39;&#39;  from sys.routes</span></td>
        </tr>
        <tr>
          <td id="L179" class="blob-num js-line-number" data-line-number="179"></td>
          <td id="LC179" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L180" class="blob-num js-line-number" data-line-number="180"></td>
          <td id="LC180" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name COLLATE database_default, fulltext_catalog_id, null, null, &#39;&#39;FULLTEXT CATALOG&#39;&#39;, &#39;&#39;FULLTEXT CATALOG&#39;&#39;  from sys.fulltext_catalogs</span></td>
        </tr>
        <tr>
          <td id="L181" class="blob-num js-line-number" data-line-number="181"></td>
          <td id="LC181" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L182" class="blob-num js-line-number" data-line-number="182"></td>
          <td id="LC182" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, symmetric_key_id, null, null, &#39;&#39;SYMMETRIC KEY&#39;&#39;, &#39;&#39;SYMMETRIC KEY&#39;&#39;  from sys.symmetric_keys</span></td>
        </tr>
        <tr>
          <td id="L183" class="blob-num js-line-number" data-line-number="183"></td>
          <td id="LC183" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L184" class="blob-num js-line-number" data-line-number="184"></td>
          <td id="LC184" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, certificate_id, null, null, &#39;&#39;CERTIFICATE&#39;&#39;, &#39;&#39;CERTIFICATE&#39;&#39; from sys.certificates</span></td>
        </tr>
        <tr>
          <td id="L185" class="blob-num js-line-number" data-line-number="185"></td>
          <td id="LC185" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						union all</span></td>
        </tr>
        <tr>
          <td id="L186" class="blob-num js-line-number" data-line-number="186"></td>
          <td id="LC186" class="blob-code blob-code-inner js-file-line"><span class="pl-c">						select name, asymmetric_key_id, null, null, &#39;&#39;ASYMMETRIC KEY&#39;&#39;, &#39;&#39;ASYMMETRIC KEY&#39;&#39; from sys.asymmetric_keys</span></td>
        </tr>
        <tr>
          <td id="L187" class="blob-num js-line-number" data-line-number="187"></td>
          <td id="LC187" class="blob-code blob-code-inner js-file-line"><span class="pl-c">				) obj</span></td>
        </tr>
        <tr>
          <td id="L188" class="blob-num js-line-number" data-line-number="188"></td>
          <td id="LC188" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	ON perm.major_id = obj.[object_id] </span></td>
        </tr>
        <tr>
          <td id="L189" class="blob-num js-line-number" data-line-number="189"></td>
          <td id="LC189" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	INNER JOIN sys.securable_classes sc on sc.class = perm.class </span></td>
        </tr>
        <tr>
          <td id="L190" class="blob-num js-line-number" data-line-number="190"></td>
          <td id="LC190" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	and sc.class_desc = obj.class_desc</span></td>
        </tr>
        <tr>
          <td id="L191" class="blob-num js-line-number" data-line-number="191"></td>
          <td id="LC191" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	LEFT OUTER JOIN sys.schemas s ON s.schema_id = obj.schema_id</span></td>
        </tr>
        <tr>
          <td id="L192" class="blob-num js-line-number" data-line-number="192"></td>
          <td id="LC192" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	LEFT OUTER JOIN sys.columns cl ON cl.column_id = perm.minor_id AND cl.[object_id] = perm.major_id</span></td>
        </tr>
        <tr>
          <td id="L193" class="blob-num js-line-number" data-line-number="193"></td>
          <td id="LC193" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	where 1=1</span></td>
        </tr>
        <tr>
          <td id="L194" class="blob-num js-line-number" data-line-number="194"></td>
          <td id="LC194" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	and perm.major_id &gt; 0</span></td>
        </tr>
        <tr>
          <td id="L195" class="blob-num js-line-number" data-line-number="195"></td>
          <td id="LC195" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	--Ignore internal principals</span></td>
        </tr>
        <tr>
          <td id="L196" class="blob-num js-line-number" data-line-number="196"></td>
          <td id="LC196" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	and u.name COLLATE database_default not in (&#39;&#39;dbo&#39;&#39;,&#39;&#39;guest&#39;&#39;,&#39;&#39;INFORMATION_SCHEMA&#39;&#39;,&#39;&#39;sys&#39;&#39;,&#39;&#39;MS_DataCollectorInternalUser&#39;&#39;,&#39;&#39;PolicyAdministratorRole&#39;&#39;,&#39;&#39;ServerGroupReaderRole&#39;&#39;</span></td>
        </tr>
        <tr>
          <td id="L197" class="blob-num js-line-number" data-line-number="197"></td>
          <td id="LC197" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	,&#39;&#39;ServerGroupAdministratorRole&#39;&#39;,&#39;&#39;TargetServersRole&#39;&#39;,&#39;&#39;SQLAgentUserRole&#39;&#39;,&#39;&#39;UtilityCMRReader&#39;&#39;,&#39;&#39;SQLAgentOperatorRole&#39;&#39;,&#39;&#39;dc_operator&#39;&#39;,&#39;&#39;dc_proxy&#39;&#39;,&#39;&#39;dc_admin&#39;&#39;,&#39;&#39;db_ssisadmin&#39;&#39;,&#39;&#39;db_ssisltduser&#39;&#39;,&#39;&#39;db_ssisoperator&#39;&#39;</span></td>
        </tr>
        <tr>
          <td id="L198" class="blob-num js-line-number" data-line-number="198"></td>
          <td id="LC198" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	,&#39;&#39;UtilityIMRWriter&#39;&#39;,&#39;&#39;UtilityIMRReader&#39;&#39;,&#39;&#39;RSExecRole&#39;&#39;,&#39;&#39;DatabaseMailUserRole&#39;&#39;)</span></td>
        </tr>
        <tr>
          <td id="L199" class="blob-num js-line-number" data-line-number="199"></td>
          <td id="LC199" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	--Ignore ## principals</span></td>
        </tr>
        <tr>
          <td id="L200" class="blob-num js-line-number" data-line-number="200"></td>
          <td id="LC200" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	and u.name COLLATE database_default not like &#39;&#39;##%##&#39;&#39;</span></td>
        </tr>
        <tr>
          <td id="L201" class="blob-num js-line-number" data-line-number="201"></td>
          <td id="LC201" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	--Ignore built-in svc accounts (not recommended anyway!)</span></td>
        </tr>
        <tr>
          <td id="L202" class="blob-num js-line-number" data-line-number="202"></td>
          <td id="LC202" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	and u.name COLLATE database_default not like &#39;&#39;NT SERVICE%&#39;&#39;</span></td>
        </tr>
        <tr>
          <td id="L203" class="blob-num js-line-number" data-line-number="203"></td>
          <td id="LC203" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	--Ignore MS shipped internal objects </span></td>
        </tr>
        <tr>
          <td id="L204" class="blob-num js-line-number" data-line-number="204"></td>
          <td id="LC204" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	and (obj.is_ms_shipped = 0 or obj.is_ms_shipped is null) </span></td>
        </tr>
        <tr>
          <td id="L205" class="blob-num js-line-number" data-line-number="205"></td>
          <td id="LC205" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	--Ignore system sprocs (be aware of your naming conventions!)</span></td>
        </tr>
        <tr>
          <td id="L206" class="blob-num js-line-number" data-line-number="206"></td>
          <td id="LC206" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	--and (obj.name not like &#39;&#39;sp_%&#39;&#39; or obj.name is null)</span></td>
        </tr>
        <tr>
          <td id="L207" class="blob-num js-line-number" data-line-number="207"></td>
          <td id="LC207" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	order by Object_Type_Desc, Principal_Name&#39;;</span></td>
        </tr>
        <tr>
          <td id="L208" class="blob-num js-line-number" data-line-number="208"></td>
          <td id="LC208" class="blob-code blob-code-inner js-file-line"><span class="pl-c"></span></td>
        </tr>
        <tr>
          <td id="L209" class="blob-num js-line-number" data-line-number="209"></td>
          <td id="LC209" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	exec (@TSQL);</span></td>
        </tr>
        <tr>
          <td id="L210" class="blob-num js-line-number" data-line-number="210"></td>
          <td id="LC210" class="blob-code blob-code-inner js-file-line"><span class="pl-c">	select @x = @x + 1;</span></td>
        </tr>
        <tr>
          <td id="L211" class="blob-num js-line-number" data-line-number="211"></td>
          <td id="LC211" class="blob-code blob-code-inner js-file-line"><span class="pl-c">END</span></td>
        </tr>
        <tr>
          <td id="L212" class="blob-num js-line-number" data-line-number="212"></td>
          <td id="LC212" class="blob-code blob-code-inner js-file-line"><span class="pl-c"></span></td>
        </tr>
        <tr>
          <td id="L213" class="blob-num js-line-number" data-line-number="213"></td>
          <td id="LC213" class="blob-code blob-code-inner js-file-line"><span class="pl-c"><span class="pl-c">*/</span></span></td>
        </tr>
  </table>
  
    <details class="details-reset details-overlay BlobToolbar position-absolute js-file-line-actions dropdown d-none" aria-hidden="true">
      <summary class="btn-octicon ml-0 px-2 p-0 bg-white border border-gray-dark rounded-1" aria-label="Inline file action toolbar">
        <svg class="octicon octicon-kebab-horizontal" viewBox="0 0 13 16" version="1.1" width="13" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M1.5 9a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3zm5 0a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3zM13 7.5a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0z"/></svg>
      </summary>
      <details-menu>
        <ul class="BlobToolbar-dropdown dropdown-menu dropdown-menu-se mt-2" style="width:185px">
          <li><clipboard-copy role="menuitem" class="dropdown-item" id="js-copy-lines" style="cursor:pointer;" data-original-text="Copy lines">Copy lines</clipboard-copy></li>
          <li><clipboard-copy role="menuitem" class="dropdown-item" id="js-copy-permalink" style="cursor:pointer;" data-original-text="Copy permalink">Copy permalink</clipboard-copy></li>
          <li><a class="dropdown-item js-update-url-with-hash" id="js-view-git-blame" role="menuitem" href="/williamadba/Public-Presentations/blame/173191158d6fd1a608f2d39495ffdea7e9fac063/SQLSat%20Dallas%202019/security%20Script%20databases.sql">View git blame</a></li>
            <li><a class="dropdown-item" id="js-new-issue" role="menuitem" href="/williamadba/Public-Presentations/issues/new">Reference in new issue</a></li>
        </ul>
      </details-menu>
    </details>
  
    </div>
  
      </div>
  
    
  
    <details class="details-reset details-overlay details-overlay-dark">
      <summary data-hotkey="l" aria-label="Jump to line"></summary>
      <details-dialog class="Box Box--overlay d-flex flex-column anim-fade-in fast linejump" aria-label="Jump to line">
        <!-- '"` --><!-- </textarea></xmp> --></option></form><form class="js-jump-to-line-form Box-body d-flex" action="" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="&#x2713;" />
          <input class="form-control flex-auto mr-3 linejump-input js-jump-to-line-field" type="text" placeholder="Jump to line&hellip;" aria-label="Jump to line" autofocus>
          <button type="submit" class="btn" data-close-dialog>Go</button>
  </form>    </details-dialog>
    </details>
  
  
  
    </div>
    <div class="modal-backdrop js-touch-events"></div>
  </div>
  
      </main>
    </div>
    
  
    </div>
  
          
  <div class="footer container-lg width-full p-responsive" role="contentinfo">
    <div class="position-relative d-flex flex-row-reverse flex-lg-row flex-wrap flex-lg-nowrap flex-justify-center flex-lg-justify-between pt-6 pb-2 mt-6 f6 text-gray border-top border-gray-light ">
      <ul class="list-style-none d-flex flex-wrap col-12 col-lg-5 flex-justify-center flex-lg-justify-between mb-2 mb-lg-0">
        <li class="mr-3 mr-lg-0">&copy; 2019 <span title="0.36597s from unicorn-6ff754db5b-6t5wt">GitHub</span>, Inc.</li>
          <li class="mr-3 mr-lg-0"><a data-ga-click="Footer, go to terms, text:terms" href="https://github.com/site/terms">Terms</a></li>
          <li class="mr-3 mr-lg-0"><a data-ga-click="Footer, go to privacy, text:privacy" href="https://github.com/site/privacy">Privacy</a></li>
          <li class="mr-3 mr-lg-0"><a data-ga-click="Footer, go to security, text:security" href="https://github.com/security">Security</a></li>
          <li class="mr-3 mr-lg-0"><a href="https://githubstatus.com/" data-ga-click="Footer, go to status, text:status">Status</a></li>
          <li><a data-ga-click="Footer, go to help, text:help" href="https://help.github.com">Help</a></li>
      </ul>
  
      <a aria-label="Homepage" title="GitHub" class="footer-octicon d-none d-lg-block mx-lg-4" href="https://github.com">
        <svg height="24" class="octicon octicon-mark-github" viewBox="0 0 16 16" version="1.1" width="24" aria-hidden="true"><path fill-rule="evenodd" d="M8 0C3.58 0 0 3.58 0 8c0 3.54 2.29 6.53 5.47 7.59.4.07.55-.17.55-.38 0-.19-.01-.82-.01-1.49-2.01.37-2.53-.49-2.69-.94-.09-.23-.48-.94-.82-1.13-.28-.15-.68-.52-.01-.53.63-.01 1.08.58 1.23.82.72 1.21 1.87.87 2.33.66.07-.52.28-.87.51-1.07-1.78-.2-3.64-.89-3.64-3.95 0-.87.31-1.59.82-2.15-.08-.2-.36-1.02.08-2.12 0 0 .67-.21 2.2.82.64-.18 1.32-.27 2-.27.68 0 1.36.09 2 .27 1.53-1.04 2.2-.82 2.2-.82.44 1.1.16 1.92.08 2.12.51.56.82 1.27.82 2.15 0 3.07-1.87 3.75-3.65 3.95.29.25.54.73.54 1.48 0 1.07-.01 1.93-.01 2.2 0 .21.15.46.55.38A8.013 8.013 0 0 0 16 8c0-4.42-3.58-8-8-8z"/></svg>
  </a>
     <ul class="list-style-none d-flex flex-wrap col-12 col-lg-5 flex-justify-center flex-lg-justify-between mb-2 mb-lg-0">
          <li class="mr-3 mr-lg-0"><a data-ga-click="Footer, go to contact, text:contact" href="https://github.com/contact">Contact GitHub</a></li>
          <li class="mr-3 mr-lg-0"><a href="https://github.com/pricing" data-ga-click="Footer, go to Pricing, text:Pricing">Pricing</a></li>
        <li class="mr-3 mr-lg-0"><a href="https://developer.github.com" data-ga-click="Footer, go to api, text:api">API</a></li>
        <li class="mr-3 mr-lg-0"><a href="https://training.github.com" data-ga-click="Footer, go to training, text:training">Training</a></li>
          <li class="mr-3 mr-lg-0"><a href="https://github.blog" data-ga-click="Footer, go to blog, text:blog">Blog</a></li>
          <li><a data-ga-click="Footer, go to about, text:about" href="https://github.com/about">About</a></li>
  
      </ul>
    </div>
    <div class="d-flex flex-justify-center pb-6">
      <span class="f6 text-gray-light"></span>
    </div>
  </div>
  
  
  
    <div id="ajax-error-message" class="ajax-error-message flash flash-error">
      <svg class="octicon octicon-alert" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.893 1.5c-.183-.31-.52-.5-.887-.5s-.703.19-.886.5L.138 13.499a.98.98 0 0 0 0 1.001c.193.31.53.501.886.501h13.964c.367 0 .704-.19.877-.5a1.03 1.03 0 0 0 .01-1.002L8.893 1.5zm.133 11.497H6.987v-2.003h2.039v2.003zm0-3.004H6.987V5.987h2.039v4.006z"/></svg>
      <button type="button" class="flash-close js-ajax-error-dismiss" aria-label="Dismiss error">
        <svg class="octicon octicon-x" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.48 8l3.75 3.75-1.48 1.48L6 9.48l-3.75 3.75-1.48-1.48L4.52 8 .77 4.25l1.48-1.48L6 6.52l3.75-3.75 1.48 1.48L7.48 8z"/></svg>
      </button>
      You can’t perform that action at this time.
    </div>
  
  
      
      <script crossorigin="anonymous" integrity="sha512-g8y61ukpuxDEU1w0B8AaXzCoZO9ZV7aUNRgrgUpMNaHulIZN5RB/pxmSXMScAroJfjz4IQFOfAZXod3O+htchg==" type="application/javascript" src="https://github.githubassets.com/assets/frameworks-341d995f.js"></script>
      
      <script crossorigin="anonymous" async="async" integrity="sha512-nWnoUeKrGoM2pM/rLqZn/tolJjPX4nYPzlgNe2vR8Qfy0VS4LlzTwf6oiN7zmQqjswJ8/0c5LRLbd9ZQ7+NUtQ==" type="application/javascript" src="https://github.githubassets.com/assets/github-bootstrap-6b12f7d4.js"></script>
      
      
      
    <div class="js-stale-session-flash stale-session-flash flash flash-warn flash-banner" hidden
      >
      <svg class="octicon octicon-alert" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M8.893 1.5c-.183-.31-.52-.5-.887-.5s-.703.19-.886.5L.138 13.499a.98.98 0 0 0 0 1.001c.193.31.53.501.886.501h13.964c.367 0 .704-.19.877-.5a1.03 1.03 0 0 0 .01-1.002L8.893 1.5zm.133 11.497H6.987v-2.003h2.039v2.003zm0-3.004H6.987V5.987h2.039v4.006z"/></svg>
      <span class="signed-in-tab-flash">You signed in with another tab or window. <a href="">Reload</a> to refresh your session.</span>
      <span class="signed-out-tab-flash">You signed out in another tab or window. <a href="">Reload</a> to refresh your session.</span>
    </div>
    <template id="site-details-dialog">
    <details class="details-reset details-overlay details-overlay-dark lh-default text-gray-dark hx_rsm" open>
      <summary role="button" aria-label="Close dialog"></summary>
      <details-dialog class="Box Box--overlay d-flex flex-column anim-fade-in fast hx_rsm-dialog hx_rsm-modal">
        <button class="Box-btn-octicon m-0 btn-octicon position-absolute right-0 top-0" type="button" aria-label="Close dialog" data-close-dialog>
          <svg class="octicon octicon-x" viewBox="0 0 12 16" version="1.1" width="12" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.48 8l3.75 3.75-1.48 1.48L6 9.48l-3.75 3.75-1.48-1.48L4.52 8 .77 4.25l1.48-1.48L6 6.52l3.75-3.75 1.48 1.48L7.48 8z"/></svg>
        </button>
        <div class="octocat-spinner my-6 js-details-dialog-spinner"></div>
      </details-dialog>
    </details>
  </template>
  
    <div class="Popover js-hovercard-content position-absolute" style="display: none; outline: none;" tabindex="0">
    <div class="Popover-message Popover-message--bottom-left Popover-message--large Box box-shadow-large" style="width:360px;">
    </div>
  </div>
  
    <div aria-live="polite" class="js-global-screen-reader-notice sr-only"></div>
  
    </body>
  </html>
  
  