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?
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