{"id":191977,"date":"2019-01-14T15:12:19","date_gmt":"2019-01-14T14:12:19","guid":{"rendered":"https:\/\/guide.jtl-software.com\/database\/settings-for-database-users\/"},"modified":"2023-06-14T14:55:33","modified_gmt":"2023-06-14T12:55:33","slug":"settings-for-database-users","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/","title":{"rendered":"Settings for database users"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2,h3\" data-toc class=\"list-wawi\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center hl-wawi\" id=\"settings-for-database-users\">Settings for database users <span id='anchor-settings-for-database-users' data-href='#settings-for-database-users' class='far fa-link' data-anchor><\/span><\/h1><h2 class=\"d-flex align-items-center hl-wawi\" id=\"connecting-to-the-sql-server\">Connecting to the SQL server <span id='anchor-connecting-to-the-sql-server' data-href='#connecting-to-the-sql-server' class='far fa-link' data-anchor><\/span><\/h2>\t<p>Microsoft SQL Server Management-Studio can connect to the SQL server in two ways.<\/p>\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"connecting-to-the-sql-server-with-the-windows-authentication\">Connecting to the SQL server with the Windows Authentication <span id='anchor-connecting-to-the-sql-server-with-the-windows-authentication' data-href='#connecting-to-the-sql-server-with-the-windows-authentication' class='far fa-link' data-anchor><\/span><\/h3>\t<p>With local systems, i.e. when the SQL server runs on the same computer or within the same domain as the current computer, you can log in with your Windows name without entering a password. In a standard installation, this function is usually enabled for the Windows account with which the SQL server was installed.<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img sizes=\"(max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" data-pswp=\"[]\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>Open Microsoft SQL Server Management Studio and select the entries as shown in the screenshot above (Servername und Authentifizierung\u00a0(Server name and Authentication)) to log in as a Windows user.<\/p>\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"connecting-to-the-sql-server-with-a-username-and-password\">Connecting to the SQL server with a username and password <span id='anchor-connecting-to-the-sql-server-with-a-username-and-password' data-href='#connecting-to-the-sql-server-with-a-username-and-password' class='far fa-link' data-anchor><\/span><\/h3>\t<p>If you cannot log in to the SQL server with the Windows Authentication, you can use a username and password. The username of the database administrator is \u201csa\u201d. An SQL user is necessary to connect JTL-Wawi to the SQL server.<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img sizes=\"(max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" data-pswp=\"[]\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>Open Microsoft SQL Server Management Studio and select the entries as shown in the screenshot above (Servername und Authentifizierung\u00a0(Server name and Authentication)) to log in as a Windows user.<\/p>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"changing-the-password-of-a-database-user-eg-user-sa\">Changing the password of a database user (e.g. user sa) <span id='anchor-changing-the-password-of-a-database-user-eg-user-sa' data-href='#changing-the-password-of-a-database-user-eg-user-sa' class='far fa-link' data-anchor><\/span><\/h2>\t<p>To change the password of a database user, log in to Microsoft SQL Server Management Studio as database admin as shown above. Proceed as follows:<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img sizes=\"(max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" data-pswp=\"[]\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>In the subfolder <span class=\"highlight\">Anmeldungen<\/span>\u00a0(Logins), right-click on the username whose password you want to change (e.g. \u201csa\u201d) and select <span class=\"highlight\">Eigenschaften<\/span>\u00a0(Properties).<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioPasswortAendernVonSA.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioPasswortAendernVonSA.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioPasswortAendernVonSA.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioPasswortAendernVonSA-1024x567.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioPasswortAendernVonSA-768x425.jpg 640w\" width=\"1141\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"632\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/ManagementStudioPasswortAendernVonSA.jpg&quot;,&quot;w&quot;:1141,&quot;h&quot;:632}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>As shown in the previous image, enter the password twice, remove the check mark in front of <span class=\"highlight\">Kennwortrichtlinie erzwingen<\/span>&nbsp;(Enforce password policy) and tick the check box for <span class=\"highlight\">Zu Anmeldeinformationen zuordnen<\/span>\u00a0(Map to Credential). The changes are applied by clicking&nbsp;<span class=\"highlight\">OK<\/span>.<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<b>Important:&nbsp;<\/b>Remember the password of the database administrator. It is necessary for working with the SQL server.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"creating-a-new-jtl-wawi-user\">Creating a new JTL-Wawi user <span id='anchor-creating-a-new-jtl-wawi-user' data-href='#creating-a-new-jtl-wawi-user' class='far fa-link' data-anchor><\/span><\/h2>\t<p>To create a new user for JTL-Wawi, log in to the database as administrator as described above. Then proceed as follows:<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungAnlegen.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungAnlegen.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungAnlegen.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungAnlegen-1024x500.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungAnlegen-768x375.jpg 640w\" width=\"1672\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"816\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/ManagementStudioNeueAnmeldungAnlegen.jpg&quot;,&quot;w&quot;:1672,&quot;h&quot;:816}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>Click <span class=\"highlight\">Sicherheit<\/span>\u00a0(Security) and right-click on <span class=\"highlight\">Anmeldungen<\/span>&nbsp;(Logins). Select <span class=\"highlight\">Neue Anmeldung<\/span>\u00a0(New login).<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog1.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog1.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog1.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog1.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog1.jpg 640w\" width=\"704\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"632\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/ManagementStudioNeueAnmeldungDialog1.jpg&quot;,&quot;w&quot;:704,&quot;h&quot;:632}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>Select <span class=\"highlight\">SQL-Server-Authentifizierung<\/span>\u00a0(SQL Server Authentication) and specify a username, password, default database and default language. The username and password for JTL-Wawi may be a maximum of 29 characters long. <b>Do NOT click on OK yet<\/b> but on the tab <span class=\"highlight\">Serverrollen<\/span>\u00a0(Server roles).<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog_Serverrollen.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog_Serverrollen.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog_Serverrollen.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog_Serverrollen.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnmeldungDialog_Serverrollen.jpg 640w\" width=\"704\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"632\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/ManagementStudioNeueAnmeldungDialog_Serverrollen.jpg&quot;,&quot;w&quot;:704,&quot;h&quot;:632}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>Select the server roles \u201cbulkadmin\u201d, \u201cdbcreator\u201d, \u201cprocessadmin\u201d and \u201cpublic\u201d. <b>Do NOT click on OK yet<\/b> but on the tab <span class=\"highlight\">Benutzerzuordnung<\/span>\u00a0(User mapping).<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnemdlungDialog_Benutzerzuordnung.jpg\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnemdlungDialog_Benutzerzuordnung.jpg\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnemdlungDialog_Benutzerzuordnung.jpg 1600w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnemdlungDialog_Benutzerzuordnung-1024x567.jpg 1024w,https:\/\/guide.jtl-software.com\/uploads\/ManagementStudioNeueAnemdlungDialog_Benutzerzuordnung-768x425.jpg 640w\" width=\"1141\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"632\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/ManagementStudioNeueAnemdlungDialog_Benutzerzuordnung.jpg&quot;,&quot;w&quot;:1141,&quot;h&quot;:632}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<p>Assign the rights \u201cdb_owner\u201d and \u201cpublic\u201d as well as the default schema \u201cdbo\u201d for all JTL-Wawi databases (eazybusiness and tenant databases). Create the user by clicking <span class=\"highlight\">OK<\/span>&nbsp;.<\/p>\n[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":191953,"menu_order":602,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-191977","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Settings for database users &#8211; JTL-Guide<\/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:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Settings for database users &#8211; JTL-Guide\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T12:55:33+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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/\",\"name\":\"Settings for database users &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2019-01-14T14:12:19+00:00\",\"dateModified\":\"2023-06-14T12:55:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Wawi\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Settings for database users\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Settings for database users &#8211; JTL-Guide","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:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/","og_locale":"en_US","og_type":"article","og_title":"Settings for database users &#8211; JTL-Guide","og_description":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/","og_site_name":"JTL-Guide","article_modified_time":"2023-06-14T12:55:33+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/","name":"Settings for database users &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2019-01-14T14:12:19+00:00","dateModified":"2023-06-14T12:55:33+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Wawi","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/"},{"@type":"ListItem","position":2,"name":"Database","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/"},{"@type":"ListItem","position":3,"name":"Settings for database users"}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=191977"}],"version-history":[{"count":4,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191977\/revisions"}],"predecessor-version":[{"id":192019,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191977\/revisions\/192019"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191953"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=191977"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=191977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}