How to generate password oracle 9i using profiles?

Asked By jafet windsor 50 points N/A Posted on - 08/26/2012

I want to know if it is possible in oracle 9i to use profiles instead of default profile to generate password management policies. If anybody knows how to generate password oracle 9i, then it will be appreciated.

• Status: Open
• Question Views: 864
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Carl Jack 10 points N/A #132768

How to generate password oracle 9i using profiles?

Hello Jafet,

The CREATE PROFILE statement is used to create a profile, and it puts a set of limits on database resources. In the event that you assign the profile to a user, the user will not be able to exceed these limits.

Note that before creating a profile, you will need to have CREATE PROFILE system privilege. And to be able to specify resource limits for a user, you must do the following:

• Enable resource limits dynamically using the  ALTER SYSTEM statement, or you can use the initialization parameter RESOURCE_LIMIT. Note that this parameter won't be able to apply to password resources, for the password resources are always enabled.
• You will need to create a profile which defines the limits using the CREATE PROFILE statement.
• And then after that you will need to assign the profile to the user using the CREATE USER or ALTER USER statement.

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/26/2012
• Question Category: Oracle Database