{"id":332,"date":"2016-01-04T09:42:00","date_gmt":"2016-01-04T09:42:00","guid":{"rendered":"https:\/\/blogfvinhas.wordpress.com\/?p=332"},"modified":"2016-01-04T09:42:00","modified_gmt":"2016-01-04T09:42:00","slug":"dar-permissoes-de-criar-jobs-a-users-sqlserver","status":"publish","type":"post","link":"https:\/\/blog.fvinhas.com\/index.php\/2016\/01\/04\/dar-permissoes-de-criar-jobs-a-users-sqlserver\/","title":{"rendered":"Dar permiss\u00f5es de criar Jobs a users SQLServer"},"content":{"rendered":"\n<p>Quando pretendemos dar permiss\u00f5es de criar Jobs a um determinado user temos que efetuar os seguintes passos:<\/p>\n\n\n\n<p>No user que pretendemos, no bot\u00e3o do lado direito escolher propriedades<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"707\" height=\"636\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-137.png?w=707\" alt=\"\" class=\"wp-image-333\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-137.png 707w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-137-300x270.png 300w\" sizes=\"auto, (max-width: 707px) 100vw, 707px\" \/><\/figure>\n\n\n\n<p>Escolhemos User Mapping e dar um clique em cima da base de dados MSDB, aparecendo a op\u00e7\u00e3o database role membership<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"707\" height=\"629\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-138.png?w=707\" alt=\"\" class=\"wp-image-334\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-138.png 707w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-138-300x267.png 300w\" sizes=\"auto, (max-width: 707px) 100vw, 707px\" \/><\/figure>\n\n\n\n<p>Escolhemos uma das 3 op\u00e7\u00f5es consoante as necessidades:<\/p>\n\n\n\n<p>SQLAgentOperator Role -&gt; Permissao maxima<\/p>\n\n\n\n<p>SQLAgentReader Role -&gt;Permissao de leitura<\/p>\n\n\n\n<p>SQLAgentUser Role -&gt; Permissao de criar e posteriormente editar, e ver, apenas os jobs criados<\/p>\n\n\n\n<p>Agora \u00e9 so testar \u2013 Espero ter ajudado<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quando pretendemos dar permiss\u00f5es de criar Jobs a um determinado user temos que efetuar os seguintes passos: No user que pretendemos, no bot\u00e3o do lado direito escolher propriedades Escolhemos User Mapping e dar um clique em cima da base de dados MSDB, aparecendo a op\u00e7\u00e3o database role membership Escolhemos uma das 3 op\u00e7\u00f5es consoante as &#8230; <a title=\"Dar permiss\u00f5es de criar Jobs a users SQLServer\" class=\"read-more\" href=\"https:\/\/blog.fvinhas.com\/index.php\/2016\/01\/04\/dar-permissoes-de-criar-jobs-a-users-sqlserver\/\" aria-label=\"Read more about Dar permiss\u00f5es de criar Jobs a users SQLServer\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[51,64,86,87],"class_list":["post-332","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-jobs","tag-permissoes","tag-sql","tag-sqlagent"],"_links":{"self":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/comments?post=332"}],"version-history":[{"count":0,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/332\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/media?parent=332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/categories?post=332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/tags?post=332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}