Question

At this stage, this environment is meant to be pushed into production and certain housekeeping items need to occur. Create a script that:
Removes the DEVELOPER account.
Locks the QA account.
Expires the Password for the QA account.

In SSMS

Answer 1

Removes the DEVELOPER account.

command:

DROP USER DEVELOPER;

Output:

Locks the QA account.

COMMAND:

alter user QUALITY_ASSURANCE account lock;

Output:

Expires the Password for the QA account:

Command:

alter user QUALITY_ASSURANCE identified by 'QAACCOUNT' expire;