Users can be created using CREATE USER.
Command syntax.
CREATE [OR REPLACE] USER name [IF NOT EXISTS]
SET PASSWORD password
[[SET PASSWORD] CHANGE [NOT] REQUIRED]
[SET STATUS {ACTIVE | SUSPENDED}]
and then provides the example of
For example, we can create the user jake in a suspended state
and the requirement to change his password.
Query.
CREATE USER jake
SET PASSWORD 'abc' CHANGE REQUIRED
SET STATUS SUSPENDED
After user creation if I choose to login into the user account to check if the assigned permission is correct then I will be prompt to change the password. Once I am done validating the user then can I run the below mentioned command to force the user to change the password again:
UPDATE USER jake
SET PASSWORD 'abcabc' CHANGE REQUIRED
ALTER USER name SET {
PASSWORD password
[[SET PASSWORD] CHANGE [NOT] REQUIRED]
[SET STATUS {ACTIVE | SUSPENDED} ] |
PASSWORD CHANGE [NOT] REQUIRED
[SET STATUS {ACTIVE | SUSPENDED}] |
STATUS {ACTIVE | SUSPENDED}
}
The password can either be a string value or a string parameter.
For example, we can modify the user jake with a new password and active status as well as remove the requirement to change his password.
Query.
ALTER USER jake
SET PASSWORD 'abc123' CHANGE NOT REQUIRED
SET STATUS ACTIVE
Did you find a UPDATE USER .... in the documentation?
