/*
(1) Create a database with the same name as a prefix of your University email account.
For example, if your University email account isabc001@uow.edu.au then a name of a database should be abc001.
0.1 mark
*/
/*
(2) Create two new user accounts. The names of user accounts and the passwords are up to you.
0.1 mark
*/
/*
(3) While connected as a user root, process the scripts dbcreate.sql and dbload.sql to create and to load data into the relational tables
later on used in this laboratory class.
All relational tables must be located in a database created in step (1).
A listing of SQL statements processed by the scripts must NOT be included in a report from processing of a script solution1.sql.
It means that before processing of the script you must process notee statement (after use database_name command) to turn the spooling off
and after processing of the scripts you must process a statement tee solution1.rpt to turn the spooling on into a report file.
0.2 marks
*/
/*
(4) Next, create two new roles: drinker and pub. Grant to a role drinker the read privileges on the entire database created in step (1).
The privileges must be granted such that any owner of a role drinker cannot grant the same privileges to another role or user.
0.2 marks
*/
/*
(5) Next, grant to a role pub a read privilege on the relational table LOCATED in the database created in step (1).
The privilege must be granted such that any owner of a role pub can grant the same privileges to another role or user.
0.2 marks
*/
/*
(6) Next, grant to a role drinker the read and write privileges on the relational table LIKES in the database created in step (1).
The privileges must be granted such that any owner of a role drinker cannot grant the same privileges to another role or user.
0.2 marks
*/
/*
(7) Next, grant to a role drinker the read privileges on the columns drinker, pub, drink in a relational table ORDERS in the database created in step (1).
The privileges must be granted such that any owner of a role drinker cannot grant the same privileges to another role or user.
0.3 marks
*/
/*
(8) Next, grant to a role pub insert privilege on a relational table SERVESin the database created in step (1).
The privileges must be granted such that any owner of a role pub can propagate the same privileges to another role or user.
0.2 marks
*/
/*
(9) Next, grant to a role pub a privilege to create relational tables in the database created in step (1).
The privileges must be granted such that any owner of a role pub cannot grant the same privileges to another role or user.
0.2 marks
*/
/*
(10) Next, grant to a role pub a privilege to create relational views located in the database created in step (1).
The privileges must be granted such that any owner of a role pub cannot grant the same privileges to another role or user.
0.2 marks
*/
/*
(11) Next, grant to a role pub the read privileges on information about the orders completed in the first three months of 2020.
A hint is on create a relational view and grant the read privileges on the view.
The privileges must be granted such that any owner of a role pub cannot grant the same privileges to another role or user.
0.5 marks
*/
/*
(12) Next, grant a role drinker to a role pub and then grant a role pub to one of the users created in step (2) and a role drinker to another user.
0.2 marks
*/
/*
(13) Next, set a resource limit on maximum total number of concurrent connections available to both users created in step (2).
The maximum number of concurrent connections is up to you.
0.2 marks
*/
/*
(14) Next, lock the accounts of the new users.
0.1 mark
*/
/*
(15) Finally, unlock one of the accounts of the new users.
0.1 mark
*/
/*
Drop the users, the roles, and the database that created
*/
The post name as a prefix of your University email account appeared first on My Assignment Online.