Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How does oracle change the password of a user to be permanent?

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "how to change the password of a user to be permanent". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to change the password of a user to be permanent" by oracle.

Set a password that will never expire. First, check which user's proifle is, usually default:

Sql > SELECT username,PROFILE FROM dba_users

View the password validity settings for the specified profile, such as default:

Sql > SELECT * FROM dba_profiles 's WHERE s.profileholders default AND resource_name='PASSWORD_LIFE_TIME'

Set the password for a user to never expire

For example, modify the password expiration rule of FSJT_USER users to UNLIMITED indefinitely.

1. New profile "FSJT_USER_UNLIMIT", the rules are the same as DEFAULT (because a profile contains a lot of items, we only want to modify the expiration rules at this time, other rules remain the same)

CREATE PROFILE "FSJT_USER_UNLIMIT" LIMIT

SESSIONS_PER_USER UNLIMITED

CPU_PER_SESSION UNLIMITED

CPU_PER_CALL UNLIMITED

CONNECT_TIME UNLIMITED

IDLE_TIME UNLIMITED

LOGICAL_READS_PER_SESSION UNLIMITED

LOGICAL_READS_PER_CALL UNLIMITED

COMPOSITE_LIMIT UNLIMITED

PRIVATE_SGA UNLIMITED

FAILED_LOGIN_ATTEMPTS 10

PASSWORD_LIFE_TIME 180

PASSWORD_REUSE_TIME UNLIMITED

PASSWORD_REUSE_MAX UNLIMITED

PASSWORD_LOCK_TIME 1

PASSWORD_GRACE_TIME 7

PASSWORD_VERIFY_FUNCTION NULL

Then check it out.

SELECT profile FROM dba_profiles

-

DEFAULT

FSJT_USER_UNLIMIT

two。 Modify the newly created profile (FSJT_USER_UNLIMIT). Password expires if it does not expire.

ALTER profile FSJT_USER_UNLIMIT limit PASSWORD_LIFE_TIME UNLIMITED

3. Modify the user's Profile to a new profile

Alter user FSJT_USER profile FSJT_USER_UNLIMIT

At this point, I believe you have a deeper understanding of "how to change the password of a user to be permanent". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report