Oracle: HOW TO CREATE USER AND GIVE GRANTS
create user [username] identified by [password] default tablespace [tablespace name which has free space acc to statement 8] quota unlimited on [same tablespace name];
create user [username] identified by [password] default tablespace [tablespace name which has free space acc to statement 8] quota unlimited on [same tablespace name];
Lock user ID : # passwd -l username Unlock user ID : # passwd -d username Unlock user ID and force user to enter new password : # passwd -df username Note: This will unlock the user id, and force the user to enter a new password at next login.
Procedure to change the password on a server # passwd <UserName> Note: The account needs to be reset if when trying to log in the following message is received: 3004-303 There have been too many unsuccessful login attempts; please see the system administrator. Procedure to reset the account: # chsec -f /etc/security/lastlog -a “unsuccessful_login_count=0” -s …