{"id":1340,"date":"2012-05-04T12:16:20","date_gmt":"2012-05-04T12:16:20","guid":{"rendered":"https:\/\/www.buarotti.ch\/?p=1340"},"modified":"2012-05-04T12:16:20","modified_gmt":"2012-05-04T12:16:20","slug":"sql-permission-roles","status":"publish","type":"post","link":"https:\/\/www.buarotti.ch\/?p=1340","title":{"rendered":"SQL Permission Roles"},"content":{"rendered":"<p>Predefined database roles<\/p>\n<p>You may need to create your own, but you have access to several predefined database roles:<\/p>\n<ul>\n<li><strong>db_owner<\/strong>: Members have full access.<\/li>\n<li><strong>db_accessadmin<\/strong>: Members can manage Windows groups and SQL Server logins.<\/li>\n<li><strong>db_datareader<\/strong>: Members can read all data.<\/li>\n<li><strong>db_datawriter<\/strong>: Members can add, delete, or modify data in the tables.<\/li>\n<li><strong>db_ddladmin<\/strong>: Members can run dynamic-link library (DLL) statements.<\/li>\n<li><strong>db_securityadmin<\/strong>: Members can modify role membership and manage permissions.<\/li>\n<li><strong>db_bckupoperator<\/strong>: Members can back up the database.<\/li>\n<li><strong>db_denydatareader<\/strong>: Members can\u2019t view data within the database.<\/li>\n<li><strong>db_denydatawriter<\/strong>: Members can\u2019t change or delete data in tables or views.<\/li>\n<\/ul>\n<p>Fixed roles<\/p>\n<p>The fixed server roles are applied serverwide, and there are several predefined server roles:<\/p>\n<ul>\n<li><strong>SysAdmin<\/strong>: Any member can perform any action on the server.<\/li>\n<li><strong>ServerAdmin<\/strong>: Any member can set configuration options on the server.<\/li>\n<li><strong>SetupAdmin<\/strong>: Any member can manage linked servers and SQL Server startup options and tasks.<\/li>\n<li><strong>Security Admin<\/strong>: Any member can manage server security.<\/li>\n<li><strong>ProcessAdmin<\/strong>: Any member can kill processes running on SQL Server.<\/li>\n<li><strong>DbCreator<\/strong>: Any member can create, alter, drop, and restore databases.<\/li>\n<li><strong>DiskAdmin<\/strong>: Any member can manage SQL Server disk files.<\/li>\n<li><strong>BulkAdmin<\/strong>: Any member can run the bulk insert command.<\/li>\n<\/ul>\n<h3>Related Images:<\/h3>","protected":false},"excerpt":{"rendered":"<p>Predefined database roles You may need to create your own, but you have access to several predefined database roles: db_owner: Members have full access. db_accessadmin: Members can manage Windows groups and SQL Server logins. db_datareader: Members can read all data. db_datawriter: Members can add, delete, or modify data in the tables. db_ddladmin: Members can run [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[33],"tags":[],"class_list":["post-1340","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=\/wp\/v2\/posts\/1340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1340"}],"version-history":[{"count":2,"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=\/wp\/v2\/posts\/1340\/revisions"}],"predecessor-version":[{"id":1342,"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=\/wp\/v2\/posts\/1340\/revisions\/1342"}],"wp:attachment":[{"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.buarotti.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}