Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pls attempt all parts for Upvote a) Discuss with appropriate SQL demonstration System privileges and Object privileges. b) As part of providing data security for

Pls attempt all parts for Upvote

a) Discuss with appropriate SQL demonstration System privileges and Object privileges.

b) As part of providing data security for East Asia Insurance database perform the following tasks.

i. Create a tablespace as your first name (i.e. Muna_Tbs) with appropriate parameters.

ii. Create a User as your first name (i.e. Muna_Usr) with appropriate privileges and link the user to the above tablespace created.

iii. Create a table as your first name (i.e. Muna_Tbl) provide and insert at least 10 records.

iv. Demonstrate practically the steps involved in backup and recovery.

c) Demonstrate with appropriate examples roles and privileges.

i. Create a user (eg. Muna1_Usr) and assign the privilege to the that he/she can connect to the database and able to create any table.

ii. Create a user (eg. Muna2_Usr) and assign the privilege to the user that he/she can connect to the database and able to insert records in the table created by Muna_Usr (i.e. Muna_tbl).

iii. Create a role of your choice (eg. Manager_Role) and assign the privilege to the role that it can able to select and insert records in the table created by Muna_Usr (i.e. Muna_tbl).

iv. Create a user (eg. Muna3_Usr) and assign the privilege to the user that he/she can connect to the database and assign the above created role (eg. Manager_Role) to the user (i.e. Muna3_Usr).

Please include the necessary SQL commands (as screenshots only) with brief explanation for each of the SQL commands.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managing Your Information How To Design And Create A Textual Database On Your Microcomputer

Authors: Tenopir, Carol, Lundeen, Gerald

1st Edition

1555700233, 9781555700232

More Books

Students also viewed these Databases questions

Question

=+How will this affect the recruiting process?

Answered: 1 week ago