EBS用户密码控制

yinhu8882000

请问有谁知道如何控制EBS普通用户密码每三个月需要改变一次呢？
有谁知道密码控制Profile?

zhenghf

　　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;

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

000fuli

如下圖:
可以在用戶設定畫面管控

yinhu8882000

zhenghf 发表于 2011/6/15 17:09
　　1、查看用户的proifle是哪个，一般是default：

　　sql>SELECT username,PROFILE FROM dba_users;

zhenghf ，你好。
这些profile是用来控制EBS用户的吗？还是控制数据库用户的呢？

zhenghf

yinhu8882000 发表于 2011/6/15 22:00
zhenghf ，你好。
这些profile是用来控制EBS用户的吗？还是控制数据库用户的呢？

呵呵，这个我也是百度出来的，我看了一下应该是限制全部用户的。

blueworm

2 樓的就是正解

3 樓的方法是針對 DB User ，在 EBS AP 裡，大家都是用 APPS 啊 {:soso_e113:}

另補充一些 Oracle AP User Password 控制項目 的說明

Password

Enter the initial password of an application user. An application user enters this

password along with his username to sign on to Oracle Applications.

• A password must be at least five (5) characters and can be up to thirty (30)

characters.

• All characters are allowed except control characters, which are non-printable.

Oracle encourages the use of non-alphanumeric characters because they add

complexity, making passwords harder to guess.

This window does not display the password you enter. After you enter a password, you

must re-enter it to ensure you did not make a typing error.

If the application user already exists and the two entries do not match, the original

password is not changed and an error message is displayed.

If you are defining a new application user and the two entries do not match, you are

required to enter the password again. For a new user, you cannot navigate to the next

field until the two entries match.

The first time an application user signs on, he must change his password. If a user

forgets his password, you can reassign a new password in this field.

As System Administrator, you can set an initial password or change an existing

password, but you cannot access the user's chosen password.

You can set the minimum length of Oracle Applications user passwords using the

profile option Signon Password Length. If this profile option is left unset, the minimum

length defaults to 5.

You can set the minimum number of days that a user must wait before being allowed to

reuse a password with the Signon Password No Reuse profile option.

You can use the profile option Signon Password Hard to Guess to set rules for choosing

passwords to ensure that they will be "hard to guess." A password is considered

hard-to-guess if it follows these rules:

• The password contains at least one letter and at least one number.

• The password does not contain the username.

• The password does not contain repeating characters.

The Signon Password Failure Limit profile option determines the maximum number of

login attempts before the user's account is disabled.

For information on case sensitivity in passwords, see: Case Sensitivity in Oracle

Applications User Passwords, page 4-7.

Password Expiration

• Days - Enter the maximum number of days between password changes. A pop-up

window prompts an application user to change his password after the maximum

number of days you specify has elapsed.

• Accesses - Enter the maximum allowed number of sign-ons to Oracle Applications

allowed between password changes. A pop-up window prompts an application

user to change his password after the maximum number of accesses you specify has

elapsed.

Tip: We recommend that you require application users to make

regular password changes. This reduces the likelihood of

unauthorized access to Oracle Applications.

  

zhenghf

blueworm 发表于 2011/6/16 14:55
2 樓的就是正解

3 樓的方法是針對 DB User ，在 EBS AP 裡，大家都是用 APPS 啊

配置文件？？？？？

davis7527

Profile Setup