{"id":201,"date":"2018-12-30T10:41:41","date_gmt":"2018-12-30T10:41:41","guid":{"rendered":"https:\/\/agency.oceanwp.org\/?post_type=ocean_portfolio&#038;p=201"},"modified":"2021-10-14T06:25:48","modified_gmt":"2021-10-14T06:25:48","slug":"id-lorem-lacinia","status":"publish","type":"ocean_portfolio","link":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia","title":{"rendered":"Create custom user login for Azure SQL"},"content":{"rendered":"<p>First, you need to create a new\u00a0<strong>login on the MASTER database<\/strong>\u00a0using the following command<\/p>\n<p><span class=\"token keyword\">CREATE<\/span> LOGIN NewDbUser <span class=\"token keyword\">WITH<\/span> PASSWORD <span class=\"token operator\">=<\/span> <span class=\"token string\">&#8216;Passw0rd&#8217;<\/span> GO<\/p>\n<p>Then you have to create a User on your database using a previously established login, and add permissions for the database using the following command<\/p>\n<p><strong>Important!<\/strong>\u00a0Do not forget to switch database, it is NOT Master anymore<\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">USER<\/span> NewDbUser <span class=\"token keyword\">FOR<\/span> LOGIN NewDbUser GO <span class=\"token keyword\">EXEC<\/span> sp_addrolemember N<span class=\"token string\">&#8216;db_owner&#8217;<\/span><span class=\"token punctuation\">,<\/span> N<span class=\"token string\">&#8216;NewDbUser&#8217;<\/span> GO<\/p>\n<p>\u00a0<\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\t\t\t\tMorbi faucibus feugiat sem, in fermentum purus. Etiam placerat felis vitae elit volutpat, eu accumsan sem semper. Suspendisse nibh erat, lobortis eu eleifend tempor,\t\t<\/p>\n","protected":false},"author":1,"featured_media":219,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"ocean_portfolio_category":[9,8],"ocean_portfolio_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create custom user login for Azure SQL - Barney Chen<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create custom user login for Azure SQL - Barney Chen\" \/>\n<meta property=\"og:description\" content=\"Morbi faucibus feugiat sem, in fermentum purus. Etiam placerat felis vitae elit volutpat, eu accumsan sem semper. Suspendisse nibh erat, lobortis eu eleifend tempor,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia\" \/>\n<meta property=\"og:site_name\" content=\"Barney Chen\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-14T06:25:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/barneychen.com\/wp-content\/uploads\/2018\/12\/post3.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/barneychen.com\/#website\",\"url\":\"https:\/\/barneychen.com\/\",\"name\":\"Barney Chen\",\"description\":\"Just a personal blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/barneychen.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/barneychen.com\/wp-content\/uploads\/2018\/12\/post3.jpeg\",\"contentUrl\":\"https:\/\/barneychen.com\/wp-content\/uploads\/2018\/12\/post3.jpeg\",\"width\":1200,\"height\":800},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#webpage\",\"url\":\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia\",\"name\":\"Create custom user login for Azure SQL - Barney Chen\",\"isPartOf\":{\"@id\":\"https:\/\/barneychen.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#primaryimage\"},\"datePublished\":\"2018-12-30T10:41:41+00:00\",\"dateModified\":\"2021-10-14T06:25:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/barneychen.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create custom user login for Azure SQL\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create custom user login for Azure SQL - Barney Chen","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia","og_locale":"en_US","og_type":"article","og_title":"Create custom user login for Azure SQL - Barney Chen","og_description":"Morbi faucibus feugiat sem, in fermentum purus. Etiam placerat felis vitae elit volutpat, eu accumsan sem semper. Suspendisse nibh erat, lobortis eu eleifend tempor,","og_url":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia","og_site_name":"Barney Chen","article_modified_time":"2021-10-14T06:25:48+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/barneychen.com\/wp-content\/uploads\/2018\/12\/post3.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/barneychen.com\/#website","url":"https:\/\/barneychen.com\/","name":"Barney Chen","description":"Just a personal blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/barneychen.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#primaryimage","inLanguage":"en-US","url":"https:\/\/barneychen.com\/wp-content\/uploads\/2018\/12\/post3.jpeg","contentUrl":"https:\/\/barneychen.com\/wp-content\/uploads\/2018\/12\/post3.jpeg","width":1200,"height":800},{"@type":"WebPage","@id":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#webpage","url":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia","name":"Create custom user login for Azure SQL - Barney Chen","isPartOf":{"@id":"https:\/\/barneychen.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#primaryimage"},"datePublished":"2018-12-30T10:41:41+00:00","dateModified":"2021-10-14T06:25:48+00:00","breadcrumb":{"@id":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/barneychen.com\/?ocean_portfolio=id-lorem-lacinia#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/barneychen.com\/"},{"@type":"ListItem","position":2,"name":"Create custom user login for Azure SQL"}]}]}},"_links":{"self":[{"href":"https:\/\/barneychen.com\/index.php?rest_route=\/wp\/v2\/ocean_portfolio\/201"}],"collection":[{"href":"https:\/\/barneychen.com\/index.php?rest_route=\/wp\/v2\/ocean_portfolio"}],"about":[{"href":"https:\/\/barneychen.com\/index.php?rest_route=\/wp\/v2\/types\/ocean_portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/barneychen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/barneychen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=201"}],"version-history":[{"count":1,"href":"https:\/\/barneychen.com\/index.php?rest_route=\/wp\/v2\/ocean_portfolio\/201\/revisions"}],"predecessor-version":[{"id":434,"href":"https:\/\/barneychen.com\/index.php?rest_route=\/wp\/v2\/ocean_portfolio\/201\/revisions\/434"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/barneychen.com\/index.php?rest_route=\/wp\/v2\/media\/219"}],"wp:attachment":[{"href":"https:\/\/barneychen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=201"}],"wp:term":[{"taxonomy":"ocean_portfolio_category","embeddable":true,"href":"https:\/\/barneychen.com\/index.php?rest_route=%2Fwp%2Fv2%2Focean_portfolio_category&post=201"},{"taxonomy":"ocean_portfolio_tag","embeddable":true,"href":"https:\/\/barneychen.com\/index.php?rest_route=%2Fwp%2Fv2%2Focean_portfolio_tag&post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}