Question description
Roles are created by users (usually administrators) to group together privileges or other roles. They are a means of facilitating the granting of multiple privileges or roles to users.
For our discussion please consider and expand on the following questions:
1) What is the difference between a database user and a schema?
2) There are users who have sysadmin rights on the entire database. is this a setting for a suer/schema or are there users who are not a schema?
3) How does this schema relate to roles?
4) Explain when and why you would use roles. For example: Assuming you have a human resources database, if you want three different users for a database: (one who can udpate it, one who can only view it, and one who cannot view salaries), how would you set that up?
Note: it just a discurssion so make it as shot as possibe like at most half a sheet
