如何关闭Oracle密码有效期? [英] How do I turn off Oracle password expiration?

问题描述

我正在使用Oracle进行开发.我一直用来重建数据库的引导程序帐户的密码已过期.

I'm using Oracle for development. The password for a bootstrap account that I always use to rebuild my database has expired.

如何永久关闭此用户(和所有其他用户)的密码有效期?

How do I turn off password expiration for this user (and all other users) permanently?

我正在使用Oracle 11g，它的密码默认情况下会过期.

I'm using Oracle 11g, which has passwords expire by default.

推荐答案

要更改Oracle中某个用户配置文件的密码过期策略，请首先检查该用户正在使用哪个配置文件:

To alter the password expiry policy for a certain user profile in Oracle first check which profile the user is using:

select profile from DBA_USERS where username = '<username>';

然后您可以使用以下方法将限制更改为永不过期:

Then you can change the limit to never expire using:

alter profile <profile_name> limit password_life_time UNLIMITED;

如果您想事先检查限额，可以使用:

If you want to previously check the limit you may use:

select resource_name,limit from dba_profiles where profile='<profile_name>';

这篇关于如何关闭Oracle密码有效期?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！