{"id":2502,"date":"2014-12-29T17:39:02","date_gmt":"2014-12-29T17:39:02","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=2502"},"modified":"2021-11-30T16:52:00","modified_gmt":"2021-11-30T23:52:00","slug":"database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/","title":{"rendered":"Database Permissions"},"content":{"rendered":"<p>Ephesoft recommends that the Transact database service account be assigned <span style=\"text-decoration: underline\"><strong>db_owner<\/strong><\/span> permissions. This is because Transact patch installers may alter the existing database. If this occurs,\u00a0it may be necessary to create a new database table or modify the schema after an upgrade or running a patch installer.<\/p>\n<p>Ephesoft Transact performs the following operations on the database server:<\/p>\n<ol>\n<li>Transact connects with the database server and creates an Application and reporting database. Transact populates tables in the reporting database at the same time.<\/li>\n<li>Transact creates a login with the name ephesoft and gives all permissions on the Application and reporting databases to this login.<\/li>\n<li>Once installation and database creation are complete, Transact will connect with the database server using the ephesoft login. Transact then creates tables in the Application database.<\/li>\n<li>Transact then performs SELECT, INSERT, DELETE and UPDATE operations on tables.<\/li>\n<\/ol>\n","protected":false},"featured_media":0,"parent":23474,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.0 (Yoast SEO v22.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database Permissions | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Permissions\" \/>\n<meta property=\"og:description\" content=\"Ephesoft recommends that the Transact database service account be assigned db_owner permissions. This is because Transact patch installers may alter [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-30T23:52:00+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/\",\"name\":\"Database Permissions | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2014-12-29T17:39:02+00:00\",\"dateModified\":\"2021-11-30T23:52:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"System Configuration\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Database Connection and Configuration\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Database Permissions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Database Permissions | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Database Permissions","og_description":"Ephesoft recommends that the Transact database service account be assigned db_owner permissions. This is because Transact patch installers may alter [&hellip;]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/","og_site_name":"Ephesoft Docs","article_modified_time":"2021-11-30T23:52:00+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/","name":"Database Permissions | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2014-12-29T17:39:02+00:00","dateModified":"2021-11-30T23:52:00+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/database-permissions-can-non-db-owner-permissions-be-assigned-for-successful-operation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"System Configuration","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/"},{"@type":"ListItem","position":4,"name":"Database Connection and Configuration","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/"},{"@type":"ListItem","position":5,"name":"Database Permissions"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/2502"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=2502"}],"version-history":[{"count":2,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/2502\/revisions"}],"predecessor-version":[{"id":49966,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/2502\/revisions\/49966"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/23474"}],"prev":[{"title":"Connecting to a MSSQL Database Over SSL","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/configurations\/database\/connecting-to-mssql-database-over-ssl\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/12614"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=2502"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=2502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}