Answered step by step
Verified Expert Solution
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
- 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
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