Home Database Mysql Tutorial 修改Oracle默认用户密码有效期时间

修改Oracle默认用户密码有效期时间

Jun 07, 2016 pm 04:56 PM
oracle database

1、查看用户的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;

  修改之后不需要重启动数据库,会立即生效。

linux

  • 0
  • 配置Oracle RAC需要注意的问题

    Oracle DDL,DML,DCL,TCL 基础概念

    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

    Hot Article Tags

    Notepad++7.3.1

    Notepad++7.3.1

    Easy-to-use and free code editor

    SublimeText3 Chinese version

    SublimeText3 Chinese version

    Chinese version, very easy to use

    Zend Studio 13.0.1

    Zend Studio 13.0.1

    Powerful PHP integrated development environment

    Dreamweaver CS6

    Dreamweaver CS6

    Visual web development tools

    SublimeText3 Mac version

    SublimeText3 Mac version

    God-level code editing software (SublimeText3)

    How long will Oracle database logs be kept? How long will Oracle database logs be kept? May 10, 2024 am 03:27 AM

    How long will Oracle database logs be kept?

    Oracle database server hardware configuration requirements Oracle database server hardware configuration requirements May 10, 2024 am 04:00 AM

    Oracle database server hardware configuration requirements

    How much memory does oracle require? How much memory does oracle require? May 10, 2024 am 04:12 AM

    How much memory does oracle require?

    How much memory is needed to use oracle database How much memory is needed to use oracle database May 10, 2024 am 03:42 AM

    How much memory is needed to use oracle database

    Oracle scheduled tasks execute the creation step once a day Oracle scheduled tasks execute the creation step once a day May 10, 2024 am 03:03 AM

    Oracle scheduled tasks execute the creation step once a day

    How much memory does an oracle database require? How much memory does an oracle database require? May 10, 2024 am 02:09 AM

    How much memory does an oracle database require?

    Detailed tutorial on establishing a database connection using MySQLi in PHP Detailed tutorial on establishing a database connection using MySQLi in PHP Jun 04, 2024 pm 01:42 PM

    Detailed tutorial on establishing a database connection using MySQLi in PHP

    How to start the listening program in oracle How to start the listening program in oracle May 10, 2024 am 03:12 AM

    How to start the listening program in oracle

    See all articles