lab5.366 - . . Fall 2007 CSC/CPE 366: Database Modeling,...

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

View Full Document Right Arrow Icon
. . Fall 2007 CSC/CPE 366: Database Modeling, Design and Implementation Alexander Dekhtyar . . Lab 5: Access Control Due date: Tuesday, March 4, 4:00pm . Lab Overview The lab is designed to give you some hands-on experience with SQL’s GRANT and REVOKE commands. The tasks require access to three user account, and therefore, are best done in groups of three (either your project team, or any other group is allowed). If your group has fewer than three people, talk to the instructor, temporary access to an extra Oracle account will be arranged. The lab’s duration is one lab period and it is due at the end of the period (plus a grace period to print the submission). Assignment Each group is expected to have access to three Oracle accounts. These accounts will be referred to as User1 , User2 and User3 . The lab consists of a number of assignments. Each assignment asks a question related to database access control rules. The goal of each team is to investigate the answer to the question. To answer each question you will have to use GRANT command to grant access to some database objects from one user to another, as well as
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/19/2008 for the course CSC 365 taught by Professor Dekhtyar during the Spring '08 term at Cal Poly.

Page1 / 3

lab5.366 - . . Fall 2007 CSC/CPE 366: Database Modeling,...

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