Use the create role command to create a role. The syntax is:
create role role_name [with passwd "password"
[, {passwd expiration | min passwd length |
max failed_logins } option_value ]]
where:
role_name – name of the new role.
password – optional password. Must be specified by any user that is using the role.
passwd expiration – specifies the password expiration interval, in days. It can be any value between 0 and 32767, inclusive.
min passwd length – specifies the minimum password length required for the specified role.
max failed_logins – specifies the number of allowable failed login attempts for the specified login.
option_value – specifies the value for passwd expiration, min passwd length, or max failed_logins.
For example, to create the intern_role without a password, enter:
create role intern_role
To create the doctor_role and assign the password “physician”, enter:
create role doctor_role with passwd "physician"
Only the system security officer can create user-defined roles.
