The following request defines user-level password security attributes for a profile called human_resources.
CREATE PROFILE human_resources AS DEFAULT DATABASE = personnel, PASSWORD = (EXPIRE = 90, MAXLOGONATTEMPTS = 10, LOCKEDUSEREXPIRE = -1);
The following request assigns the human_resources profile to user marks.
MODIFY USER marks AS PROFILE = human_resources;