This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Spring '11
- Computer Science