Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started