首页 > 代码库 > Oracle Profile

Oracle Profile

Oracle Profile操作

--查看用户的默认PROFILE信息select username,b.* from dba_users a,dba_profiles b where a.profile=b.profile and username = PRECISE_DB;--设置用户的默认PROFILE相关参数信息alter profile default limit PASSWORD_LIFE_TIME unlimited;--创建用户的profilecreate profile app_users2 limit              failed_login_attempts 5              password_life_time 60              password_reuse_time 60              password_reuse_max 5              password_verify_function verify_function              password_lock_time 1/24              password_grace_time 10;--设置用户的profilealter user arcerzhang profile default;