Scribd
Upload
38 views2 pages

Project

1. The document describes a database mini-project involving SQL commands for creating database users and permissions. It involves creating a Bank database with a Customer table and different users like Clerk, Cashier, Auditor, and Manager. 2. It then asks to write SQL commands to grant specific permissions to the users, such as letting users insert/read from tables, grant privileges to other users, and revoke privileges from some users. 3. Students are instructed to submit the assignment as a softcopy through Google Classroom by the due date of November 10, 2023. Answers should be clear, precise, and address each question directly.

Uploaded by

surafel123emiru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
38 views2 pages

Project

1. The document describes a database mini-project involving SQL commands for creating database users and permissions. It involves creating a Bank database with a Customer table and different users like Clerk, Cashier, Auditor, and Manager. 2. It then asks to write SQL commands to grant specific permissions to the users, such as letting users insert/read from tables, grant privileges to other users, and revoke privileges from some users. 3. Students are instructed to submit the assignment as a softcopy through Google Classroom by the due date of November 10, 2023. Answers should be clear, precise, and address each question directly.

Uploaded by

surafel123emiru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Borana University

College of Natural and Computational science


Department of Computer Science
Advanced database system Miniproject (20%)

1. Briefly write commands for the following


a) Create Bank Manager has a database administrator DBA user and create the Customer table
with the relevant attributes and insert at least 10 customer records under Bank Manager user
login. (Note:- Assume what all attributes required for a customer in bank).
b) Create 4 different users in bank for each work under Bank Manager login. (like clerk, cashier,
auditor & manager).
c) Create different views to every user which you created in 2nd Step which is necessary to that
particular user as per the bank role.
d) Give any user only view permission as per the realistic bank role.
e) Give any user only to update permission the balance attribute when there is a cash deposit or
cash withdrawal as per the realistic bank role.
f) Give auditor only delete permission and show any delete transaction.

2. Suppose that the database administrator(DBA) creates four users: user1, user2, user3 and user4.
DBA issue the following GRANT command in SQL

“GRANT CREATETAB TO user2;”

And suppose that user2 creates the three base tables department, student and course.

Do the following questions based on the given direction.

a) Write SQL command, if user2 wants to grant user3 the privilege to enter and read rows in student
relation, and also user2 wants user3 to be able to propagate these privileges to other user.
b) Write SQL command, based on question number A, if user3 wants to grant user1 the privilege to
insert data in the student relation, but user3 does not want user1 to be able to propagate these
privileges to other user.

c) Write SQL command, if user2 wants to grant all users the privilege to insert, delete, update and
delete rows in the three relations, but each user does not want to be able to propagate these
privileges to other user.

d) Write SQL command, Based on question number C if user2 decides to revoke the insert and delete
privilege on the all relations from user1 and user4.

NOTE

 The answer should be clear, precise and to the point as per the question context.
 Please don’t share your assignment with other group if you so do, your assignment will be
invalid.
 Assignment should be submit by a softcopy
 Assignment should be submit through google classroom up to due date announced(November
10, 2023) on google classroom but after due date the google system not allow for you to submit
your assignment.

You might also like