{"id":14051,"date":"2025-11-21T20:38:31","date_gmt":"2025-11-21T20:38:31","guid":{"rendered":"https:\/\/learning.pcrecruiter.net\/site\/?post_type=docs&#038;p=14051"},"modified":"2025-11-21T20:44:59","modified_gmt":"2025-11-21T20:44:59","password":"","slug":"database-security","status":"publish","type":"docs","link":"https:\/\/learning.pcrecruiter.net\/site\/docs\/database-management\/database-security\/","title":{"rendered":"Database Security"},"content":{"rendered":"\n<p>In addition to the <a href=\"https:\/\/learning.pcrecruiter.net\/site\/docs\/user-settings\/user-security\/\" data-type=\"docs\" data-id=\"5169\">User Security<\/a> settings, the system also offers database-wide security options.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open <strong>System<\/strong> in the Main Menu<\/li>\n\n\n\n<li>Select <strong>Database Maintenance<\/strong> from the submenu.<\/li>\n\n\n\n<li>Open <strong>Security Settings<\/strong><\/li>\n<\/ol>\n\n\n\n<p>Within this panel are three areas to configure.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Restrictions<\/h3>\n\n\n\n<h5 class=\"wp-block-heading\">User Security Level<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Global Level Security:<\/strong> Default, unrestricted behavior.<\/li>\n\n\n\n<li><strong>User Level Security: <\/strong>Users can only see records bearing their own USERNAME. This applies broadly and can prevent users from seeing candidates, form letters, etc. Use with caution.<\/li>\n\n\n\n<li><strong>Record Level Security:<\/strong> This setting locks the user out of Positions that do not belong to their account. All other content remains visible.<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">Allow \/ Whitelist IP Addresses<\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Allow only these IP addresses:<\/strong> List IPs or ranges (append &#8216;\/24&#8217; for a Class C subnet) one per line. Anyone attempting to log in from any non-listed IP will be blocked (regardless of system administrator status). This is recommended if you are storing sensitive data such as government identifications, banking details, or other critical info in your database. <strong>Be sure to add your own IP to the list.<\/strong><\/li>\n\n\n\n<li><strong>Whitelist these IP addresses:<\/strong> PCR will automatically log you out if your IP address changes. If your public IP address changes on a regular basis, add the possible addresses to this list to allow hopping between them without losing the session. After the IP address, append &#8216;\/24&#8217; for a Class C subnet. The whitelist takes precedence over the &#8216;Allow only&#8217; list.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Password<\/h3>\n\n\n\n<p>This panel defines the parameters for &#8216;Strong Password&#8217; creation, automatic expiration of passwords, and so on:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Require strong passwords\n<ul class=\"wp-block-list\">\n<li>Require Symbol<\/li>\n\n\n\n<li>Require Letter<\/li>\n\n\n\n<li>Require Number<\/li>\n\n\n\n<li>Require Upper Case Letter<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Allow only secure connections (HTTPS)<\/li>\n\n\n\n<li>Maximum Failed Logon Attempts<\/li>\n\n\n\n<li>Minimum Password Length<\/li>\n\n\n\n<li>Password to expire (default for new users)<\/li>\n\n\n\n<li>Maximum password age &#8211; in days<\/li>\n\n\n\n<li>Warn before expiring &#8211; in days (-1 for never)<\/li>\n\n\n\n<li>Allow Password to be re-used<\/li>\n\n\n\n<li>Days before password re-use (-1 for unlimited)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Encryption<\/h3>\n\n\n\n<p>[This feature is deprecated &#8211; for encrypted fields, see <a href=\"https:\/\/learning.pcrecruiter.net\/site\/docs\/database-management\/encryption-security\/\" data-type=\"docs\" data-id=\"12013\">Encryption Security<\/a>.]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In addition to the User Security settings, the system also offers database-wide security options. Within this panel are three areas to configure. Restrictions User Security Level Allow \/ Whitelist IP Addresses Password This panel defines the parameters for &#8216;Strong Password&#8217; creation, automatic expiration of passwords, and so on: Encryption [This feature is deprecated &#8211; for&hellip; <a class=\"more-link\" href=\"https:\/\/learning.pcrecruiter.net\/site\/docs\/database-management\/database-security\/\">Continue reading <span class=\"screen-reader-text\">Database Security<\/span><\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"pcr-menu-id":[],"footnotes":""},"doc_category":[43],"doc_tag":[],"knowledge_base":[25],"class_list":["post-14051","docs","type-docs","status-publish","hentry","doc_category-database-management","knowledge_base-nine","entry"],"year_month":"2026-04","word_count":321,"total_views":"196","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"PCRecruiter","author_nicename":"arothman","author_url":"https:\/\/learning.pcrecruiter.net\/site\/author\/arothman\/"},"doc_category_info":[{"term_name":"Database Management","term_url":"https:\/\/learning.pcrecruiter.net\/site\/docs\/nine\/database-management\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"PCRecruiter 9","term_url":"https:\/\/learning.pcrecruiter.net\/site\/docs\/nine\/","term_slug":"nine"}],"knowledge_base_slug":["nine"],"_links":{"self":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/14051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/comments?post=14051"}],"version-history":[{"count":5,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/14051\/revisions"}],"predecessor-version":[{"id":14164,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/docs\/14051\/revisions\/14164"}],"wp:attachment":[{"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/media?parent=14051"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/doc_category?post=14051"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/doc_tag?post=14051"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/learning.pcrecruiter.net\/site\/wp-json\/wp\/v2\/knowledge_base?post=14051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}