CREATE USER jujuonit IDENTIFIED BY 12345password Assign the

CREATE USER jujuonit IDENTIFIED BY; 12345password

Assign the account created in Assignment 1 the CUSTOMER REP role, Create & execute on SQL statements.

Solution

CREATE USER jujuonit IDENTIFIED BY 12345
CREATE LOGIN jujuonit WITH PASSWORD = \'<12345>\';
CREATE USER jujuonit FROM LOGIN jujuonit;
ALTER ROLE dbmanager ADD MEMBER jujuonit;
ALTER ROLE dbmanager ADD MEMBER [ jujuonit @xyz.com];