a) As part of providing data security for Bank GCC database, demonstrate practically the steps involved in user level data backup and recovery.

• You must create a user as your first name (e.g. Salim ), provide appropriate privileges for creating table(s) and insert records.

Your solution must include brief explanation of all the parameters and SQL commands and screenshots showing the steps.

b) Create three database users assign the privileges as given below:

• Assign the privilege to the three users so that they can connect to the database.

• User1 should be able to create any table (e.g. table1) in the database and insert records into it. User1 should be allocated at least 5MB space in the Users tablespace.

• User2 should be able to insert records in the table created by User1 (i.e. table1).

• User3 should be only able to the view the records from the table created by User1 (i.e. table1).

• Both User1 and User2 should not be able to insert records on weekend holiday i.e. Friday.

Note: Your solution must include the necessary SQL commands (as screenshots only) with brief explanation for each of the SQL commands. User name should be based on your first name (e.g. Salim1, Salim2, and Salim3).

DO NOT DIRECTLY COPY/PASTE FROM INTERNET/BOOKS! DO NOT COPY FROM ONE

ANOTHER! PRODUCE YOUR OWN ASSIGNMENT SOLUTION REPORT. The work submitted must

be your own and must not be based on inputs from others. Your assignments shall be

submitted to electronic databases to identify plagiarism. If assignment is found to be plagiarised, action will be initiated. Please refer to MEC policy on plagiarism the Student

6 mins ago
REQUIREMENTS

The post Database administrator oracal SQL appeared first on Essaysholic.

Would you like to get in touh with us?
Contact Us