修改Oracle默认用户密码有效期时间
Jun 07, 2016 pm 04:56 PM1、查看用户的proifle是哪个,一般是default: sqlgt;SELECT username,PROFILE FROM dba_users; 2、查看指定概要文件
修改Oracle默认用户密码有效期时间
[日期:2010-03-03] 来源:Linux社区 作者:Linux编辑 [字体:]
1、查看用户的proifle是哪个,,一般是default:
sql>SELECT username,PROFILE FROM dba_users;
2、查看指定概要文件(如default)的密码有效期设置:
sql>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3、将密码有效期由默认的180天修改成“无限制”:
sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
修改之后不需要重启动数据库,会立即生效。
配置Oracle RAC需要注意的问题
Oracle DDL,DML,DCL,TCL 基础概念

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How long will Oracle database logs be kept?

Oracle database server hardware configuration requirements

How much memory is needed to use oracle database

Oracle scheduled tasks execute the creation step once a day

How much memory does an oracle database require?

Detailed tutorial on establishing a database connection using MySQLi in PHP

How to start the listening program in oracle
