#User roles
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.
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.
Need a quick solution to this question? Comment on this post!!!
Get Assignment help from the expert. DBMS Assignment Help ,just question answer is one of the best online homework market place, where you can tutor for any subject
ReplyDelete