N/APosted 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.
How to generate password oracle 9i using profiles?
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
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
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
And then after that you will need to assign the profile to the user using the