Application Question(s) PS: This is a group assessment, max: 3 members per group, use hypothetical data...

Transcribed Image Text:

Application Question(s) PS: This is a group assessment, max: 3 members per group, use hypothetical data where necessary. Question 1 (1st Group Member) Write an SQL query to differentiate between system privileges and object privileges in a Database. Question 3 (1st Group Member) Create a role named finance role and grant it the following privileges: Question 2 (3rd Group Member) (5 marks): You have a table named employees in your Oracle database. Create a user named hr_user and grant SELECT and INSERT object privileges on the employees table to this user. Provide the SQL commands to achieve this. (7 marks): • SELECT privilege on the invoices table • INSERT privilege on the transactions table 30 Marks (3 marks): Next, create a user named finance_user and assign the finance_role to this user. Provide the SQL commands to perform these tasks. Question 5 (3rd Group Member) Write SQL queries to demonstrate the following: Question 4 (2nd Group Member) (8 marks): Consider a scenario where you have a complex SQL query that involves joining multiple tables (orders, customers, and products). Write an SQL script to create this query and grant SELECT privilege on the necessary tables to a user named report_user so that they can execute this query successfully. Explain the steps you took and why each privilege is needed as comments on your SQL script. End of Formative Assessment 4 (7 marks): • Grant the CREATE TABLE system privilege to a user named admin_user. • Revoke the UPDATE object privilege on the inventory table from a user named inventory manager, [Total = 30 Marks] Grand Total: 30 Rubric Criteria Question 1: Differentiating Privileges Question 2: Granting Object Privileges Question 3: Using Roles Question 4: Granting Privileges for a Query Question 5: Granting/Revoking Privileges Total: Excellent (3 Marks) (5 Marks) (7 Marks) (8-7 Marks) (7 Marks) Good (4 Marks) (2 Marks) (6-5 Marks) (6-5 Marks) Satisfactory (6-5 Marks) (3 Marks) (4-3 Marks) (4-3 Marks) (4-3 Marks) Needs Improvement (1 Mark) (2-1 Marks) (2-1 Marks) (2-1 Marks) (2-1 Marks) Inadequate (0 Mark) (0 Mark) (0 Mark) (0 Mark) (0 Mark) Mark allocated /30 Application Question(s) PS: This is a group assessment, max: 3 members per group, use hypothetical data where necessary. Question 1 (1st Group Member) Write an SQL query to differentiate between system privileges and object privileges in a Database. Question 3 (1st Group Member) Create a role named finance role and grant it the following privileges: Question 2 (3rd Group Member) (5 marks): You have a table named employees in your Oracle database. Create a user named hr_user and grant SELECT and INSERT object privileges on the employees table to this user. Provide the SQL commands to achieve this. (7 marks): • SELECT privilege on the invoices table • INSERT privilege on the transactions table 30 Marks (3 marks): Next, create a user named finance_user and assign the finance_role to this user. Provide the SQL commands to perform these tasks. Question 5 (3rd Group Member) Write SQL queries to demonstrate the following: Question 4 (2nd Group Member) (8 marks): Consider a scenario where you have a complex SQL query that involves joining multiple tables (orders, customers, and products). Write an SQL script to create this query and grant SELECT privilege on the necessary tables to a user named report_user so that they can execute this query successfully. Explain the steps you took and why each privilege is needed as comments on your SQL script. End of Formative Assessment 4 (7 marks): • Grant the CREATE TABLE system privilege to a user named admin_user. • Revoke the UPDATE object privilege on the inventory table from a user named inventory manager, [Total = 30 Marks] Grand Total: 30 Rubric Criteria Question 1: Differentiating Privileges Question 2: Granting Object Privileges Question 3: Using Roles Question 4: Granting Privileges for a Query Question 5: Granting/Revoking Privileges Total: Excellent (3 Marks) (5 Marks) (7 Marks) (8-7 Marks) (7 Marks) Good (4 Marks) (2 Marks) (6-5 Marks) (6-5 Marks) Satisfactory (6-5 Marks) (3 Marks) (4-3 Marks) (4-3 Marks) (4-3 Marks) Needs Improvement (1 Mark) (2-1 Marks) (2-1 Marks) (2-1 Marks) (2-1 Marks) Inadequate (0 Mark) (0 Mark) (0 Mark) (0 Mark) (0 Mark) Mark allocated /30

Answer rating: 100% (QA)

I apologize for the repetition in the questions Lets proceed with answering the revised questions Question 1 1 Group Member To differentiate between system privileges and object privileges in a databa... View the full answer