access control discurssion
Our papers are 100% unique and written following academic standards and provided requirements. Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Rely on us and be on schedule! With our help, you'll never have to worry about deadlines again. Take advantage of our current 20% discount by using the coupon code GET20
Order a Similar Paper Order a Different Paper
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.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
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