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

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support