diff options
| author | jakefeasel <jfeasel@gmail.com> | 2015-06-07 13:40:23 -0700 |
|---|---|---|
| committer | jakefeasel <jfeasel@gmail.com> | 2015-06-07 13:40:23 -0700 |
| commit | 6adcf81823b0d4206212c4cd801f73ab0adea92d (patch) | |
| tree | 52c0f903d1edf61bc7779d98d2b62a7365c61638 | |
| parent | 3a45a5501a04a794144fe876baca67320d9ef800 (diff) | |
| download | sqlfiddle2-6adcf81823b0d4206212c4cd801f73ab0adea92d.zip sqlfiddle2-6adcf81823b0d4206212c4cd801f73ab0adea92d.tar.gz sqlfiddle2-6adcf81823b0d4206212c4cd801f73ab0adea92d.tar.bz2 | |
Preventing the expiration of Oracle user passwords
| -rw-r--r-- | src/main/resources/db/oracle/setup.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/main/resources/db/oracle/setup.sql b/src/main/resources/db/oracle/setup.sql index 90ae339..d0a5b43 100644 --- a/src/main/resources/db/oracle/setup.sql +++ b/src/main/resources/db/oracle/setup.sql @@ -1,5 +1,7 @@ +ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; + CREATE TABLESPACE fiddledata DATAFILE 'fiddledata_01.dat' SIZE 500K REUSE AUTOEXTEND ON NEXT 500K MAXSIZE 500M; CREATE PROFILE fiddleusers LIMIT CPU_PER_CALL 300 PRIVATE_SGA 5K; -exit
\ No newline at end of file +exit |