You want to create a second user called admin2 with the same privileges as the...

Oracle 1z0-915-1 Question Answer

You want to create a second user called admin2 with the same privileges as the administrator specified when creating the DB system.

Which statement helps you achieve this?

CREATE USER admin2 IDENTIFIED BY ‘Password’ DEFAULT ROLE ‘administrator’;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT SUPER ON *.* TO admin2 WITH GRANT OPTION;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT AUDIT_ADMIN, BACKUP_ADMIN, SESSION_VARIABLES_ADMIN ON *.* TO admin2 WITH GRANT OPTION;

CREATE USER admin2 IDENTIFIED BY ‘Password’; GRANT ALL PRIVILEGES ON *.* TO admin2 WITH GRANT OPTION;

1z0-915-1 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"