2011_COS326_Prac8 - 2 or more values of your choice. 1....

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
School of Information Technology Department of Computer Science COS 326 – Database Systems Practical 3 Practical Date: 14 October 2011 (Friday) Tasks and Questions: Perform the following queries using SQL. Create the following 3 group roles : owner, manager, staff; as for inheritance the manager group inherit from staff, and owner inherited from manager. Give these groups no specific privileges at this stage. Create the following roles and assign them to the assigned groups: Role Name Assigned Group David Owner Piper Manager Tim Manager Kyla Staff Ryan Staff Julie Staff Assign privileges as follows: The owner group role will be a super user (meaning that this type of user can perform any action). The manager group role will be able to insert, update and delete.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The staff group role will only be able to select. Create the following table: Products. The table has two columns; Item and Price. Populate it with
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2 or more values of your choice. 1. Which users are able to perform a SELECT query on the table? Was the result as you expected, if not give a reason for this? 2. Which users are able to perform an INSERT query on the table? 3. If the group role staff is removed, what effect does this have on the previous members of the group (for example; do they still have their access)? Create a new table, which inherit the Product table, called Supplies. This table has two column, product and vendor. Populate the table with two or more value of your choice. 4. Are the members of the manager group able to access the table? 5. What happens when the UPDATE rights of Tim is revoked on the product table? 6. Now drop the Products table, what effect does this have on the access rights of the manager group member to the Supplier table....
View Full Document

Page1 / 2

2011_COS326_Prac8 - 2 or more values of your choice. 1....

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online