Question

Describe different roles that an insurance company might create to manage user groups. This is for ORACLE 12c: SQL

Answer 1

In an insurance company or any other company, a user role with respect to the Database determines what they can and cannot do in the respect of the database and also what operations they can execute on the database. User groups are created for better control and management of the users once they are added to a user group. For an insurance company where there are going to be a lot of confidential information, maintenance of the user groups and correct operational configuration is very important. Thus, the different roles that an insurance company might create to manage user groups are:

a) Security Administrators - Is the role which consists of the users who are able to modify role membership and manage permissions and add users and make modifications to the database security.

b) Access administrators - who can control the user access roles and can add or remove access to the database.

c) Owner of the database - This role can perform all the configuration and maintenance activities on the database and can make all sorts of changes to the database.

d) Backup operators - is the user role where the users of this role can back up the database.

e) Data Definition Language (DDL) admin - users in this role can run any Data Definition Language (DDL) command on the database.

f) Data writers role - users in this role can add, delete, or change data in all user tables.

g) Data Readers role - users in this role can read all data from all user tables.

h) Deby Data Reader - users in this role cannot read any data in the user tables within a database.

i) Deny Data Writers - users in this role cannot add, modify, or delete any data in the user tables within a database.