Assume that you are the DBA of the banking organization . One responsibility of DBA is to manage the user access and user profiles. Perform the following tasks by writing the proper SQL statements:
a. Identify and create at least three (3) different roles and provide proper justification for all the three identified roles.
b. Create at least two (2) profiles with different parameters that can be applicable to the bank and justify the requirement of profiles.
c. Create at least six (6) users and assign appropriate profiles from the profiles that as you have created above.
d. Grant the appropriate roles from the three created roles to the users that have been created above.
e. Critically analyze the role of default and temporary tablespaces while creating users.
Note: Your answers should be in MS Word format and you have to provide the screenshots of the commands that you have executed in Oracle or any other database environment in the appendix.