不使用Oracle缺省的default profile

create profile in oracle,不使用Oracle缺省的default profile
2010-05-26 21:04
最近现网部署实施时，由于数据库密码配置错误，导致数据库帐户被锁定。由此，想到创建的数据库用户一般都是使用缺省的Oracle的default profile。 有些时候，我们需要自定义profile策略,如下:
CREATE PROFILE mybusiness LIMIT
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED //session_per_user 10
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED //Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.
CONNECT_TIME UNLIMITED //Specify the total elapsed time limit for a session, expressed in minutes.
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED //失败的尝试登录次数,例如设置为10，则10次失败的登录后，该账户被锁定
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
alter use username1 profile mybusiness

延伸阅读