Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

- You are just hired as a database sccurity analyst. CIO asks you to implement the following database policy. The table names created in the

image text in transcribedimage text in transcribedimage text in transcribed

- You are just hired as a database sccurity analyst. CIO asks you to implement the following database policy. The table names created in the CardinalDB database must be prefixed with "tb_\%". This is NOT about stored procedures. You must create two conditions. - Use the following database and tables for the testing of Task 3 below after you created the policy. CREATE TABLE [dbo]. [Department2] [DepartmentID] [int] NOT NULI, [DepartmentName] [nvarchar] (50) NOT NULI, [DepartmentDescrp] [nvarchar] (50) NoT NULL, CREATE TABLE [dbo]. [tb_Department3] [DepartmentID] [int] NOT NULI, [DepartmentName] [nvarchar](50) NoT NULL, [DepartmentDescrp] [nvarchar] (50) NoT NULI, CREATE TABLE [dbo]. [tb_Department4] [DepartmentID] [int] NOT NULL, [DepartmentName] [nvarchar] (50) NOT NULI, [DepartmentDescrp] [nvarchar] (50) NOT NULL, - Use the following steps in defining policies. Step 1: Select a target facet that contains the properties to be configured. Step 2: Creatc a condition that specifies the state of a management facet. Step 3: Define a policy that contains the condition, additional conditions that filter the target sets, and the evaluation mode. Step 4: Check whether an instance of SQL Server is in compliance with the policy. - Hints (very important): - When creating a new policy: Create New Policy > Check condition > click on the drop-down menu and scroll down to view the full list of available conditions. - When creating a new policy: Hvaluation Mode On demand and On schedule are available. Select On demand. - After crcating conditions and policies, crealc the four sample tables. And you must evaluate the policy on the created tables. Figure out how to evaluate the policy. You do not need to enable the policy. - Screenshots should show the full contents of the conditions and policy you have created, not just the names. - Task 1 (5 points). Show in a screenshot the condition(s) you have created. - Task 2 (5 points). Show in a screenshot the policy you have created. - Task 3 (5 points). Show in a screenshot the test results using the four tables that are provided above. The result of the testing should look like this. - Task 4 (5 points). Explain the results at Task 3

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

Database Systems Introduction To Databases And Data Warehouses

Authors: Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov

1st Edition

1943153191, 978-1943153190

More Books

Students also viewed these Databases questions