SQL

$8.$ The DBA needs to create and execute a VIEW called P$\_$LIST that lists the Cardholder ID$,$ last name, first name, city and due date for all cardholders who have not returned a book.

$9.$ The DBA would like to execute a select on this VIEW and make it available to all users in the role and commit his work.

$10.$ The new user hears about this new VIEW and wishes to try it out by doing a select of all records on the VIEW.

$11.$ The DBA would like to create another role called DBA$\_$ROLE and grant UPDATE and SELECT access to all four $(4)$ of his tables from this database to the following existing users: stud$1,$ stud$2,$ and stud$3.$