You need to create a new user named assocdba1 and a new role


You need to create a new user named ASSOCDBA1 and a new ROLE named JRDBA1 that can be used for an assistant DBA. You want the new role to contain the DBA role that the SYSTEM user has with ADMIN OPTION (when it pertains to the current SYSTEM user setting). You also want the new role to be password-protected with a password of MJOAG2T. Once the role is created, assign the role to the new user ASSOCDBA1, but do not make it the default role.

Execute your script to create the new user, the new ROLE, assign privileges to the role, and assignment of the ROLE to the user.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: You need to create a new user named assocdba1 and a new role
Reference No:- TGS0145723

Expected delivery within 24 Hours