Difference between revisions of "GOCDB/Regional Module Technical Documentation/DeployOnOracle"
Jump to navigation
Jump to search
(Created page with "===Oracle DB Preparation Example=== We advise that you create a dedicated GOCDB user. For Oracle, you can create the gocdb user with the following script (substitute <PASSWORD...") |
|||
Line 1: | Line 1: | ||
[[GOCDB/Regional_Module_Technical_Documentation|<<Back to Install]] | |||
=Oracle DB Preparation Example= | |||
We advise that you create a dedicated GOCDB user. For Oracle, you can create the gocdb user with the following script (substitute <PASSWORD> with a sensible password and run as system user): | We advise that you create a dedicated GOCDB user. For Oracle, you can create the gocdb user with the following script (substitute <PASSWORD> with a sensible password and run as system user): | ||
<pre> | <pre> | ||
Line 18: | Line 20: | ||
</pre> | </pre> | ||
== Manage the GOCDB password expiry == | |||
By default, Oracle 11g <b>will expire a password in 180 days</b>. In previous versions of Oracle, the default policy was UNLIMITED, so please be aware of this change! As a system user, you can see your password expiry settings by looking at the PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME parameters in the DBA_PROFILES table: | By default, Oracle 11g <b>will expire a password in 180 days</b>. In previous versions of Oracle, the default policy was UNLIMITED, so please be aware of this change! As a system user, you can see your password expiry settings by looking at the PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME parameters in the DBA_PROFILES table: | ||
Revision as of 19:00, 14 November 2013
Oracle DB Preparation Example
We advise that you create a dedicated GOCDB user. For Oracle, you can create the gocdb user with the following script (substitute <PASSWORD> with a sensible password and run as system user):
-- CREATE USER SQL CREATE USER GOCDB IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; -- ROLES GRANT "RESOURCE" TO GOCDB ; -- SYSTEM PRIVILEGES GRANT CREATE TRIGGER TO GOCDB ; GRANT CREATE SEQUENCE TO GOCDB ; GRANT CREATE TABLE TO GOCDB ; GRANT CREATE JOB TO GOCDB ; GRANT CREATE PROCEDURE TO GOCDB ; GRANT CREATE TYPE TO GOCDB ; GRANT CREATE SESSION TO GOCDB ;
Manage the GOCDB password expiry
By default, Oracle 11g will expire a password in 180 days. In previous versions of Oracle, the default policy was UNLIMITED, so please be aware of this change! As a system user, you can see your password expiry settings by looking at the PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME parameters in the DBA_PROFILES table:
-- select the profile for the GOCDB user (e.g. will return DEFAULT) SELECT profile FROM dba_users WHERE username = 'GOCDB'; -- select the password expiry settings for the profile assigned to the GOCDB user select resource_name,resource_type, limit from dba_profiles where profile=DEFAULT;
If you prefer, you can update the default expiry from 180days to UNLIMITED using the following (assumng GOCDB user profile is DEFAULT):
-- requires system privilege ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;