How to generate password oracle 9i using profiles?

Asked By 50 points N/A Posted on -

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.

Answered By 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.



Login/Register to Answer

Related Questions