Archives of the TeradataForum

Message Posted: Tue, 21 Apr 2009 @ 19:59:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, April 21, 2009 14:23 -->

I am having hard time implementing the Object Access Filter in TD 12. I want to restrict access to a particular database during the Online Window (8AM b 6 PM). I have created the Periodb s under

System Regulation b Operating Environments b Periods by name Batch and Online. Batch (6PM-8AM)

I have created the Object Access Filter, with Context, Query, enabled it. But biggest problem is I donb t know how to associate the period(online or batch) with the Filter. The example from the manual is not clear.

From the manual: It is not clear how to associate WorkHours with the filter

Scenario Two

The users in the finance division adversely impact system performance by generating large financial reports during work hours (Monday through Friday from 8:00 A.M. to 5:00 P.M.). The queries that generate these reports access the NewProducts development database, which prompts complaints from the developers.

There are dozens of finance division users, whose logons are prefixed with fn_. You want to create a rule to limit the Finance division from accessing the NewProducts database during work hours:

1 Use Teradata Administrator to create a profile that includes all the fn_ users. See Teradata Administrator User Guide for instructions.

2 Open Teradata Dynamic Workload Manager.

3 Under System Regulation on the Rules DIT, select Periods.

a Select New Period, and create a period named WorkHours.

b Clear Everyday.

c Select Monday, Tuesday, Wednesday, Thursday, and Friday.

d Clear the 24 Hours check box.

e Enter 08:00 for From and 17:00 for To.

f Select Accept to accept your changes.

4 From the Rules menu, select Filter > Create > Object Access Rule. The Object Access Rule dialog box opens.

a Enter a rule name and description in the Name and Description boxes.

b Select the Restrict object combinations check box.

c Select OK to close the Object Access Rule dialog box and return to the Teradata Dynamic Workload Manager.

5 In the Database Browser:

a Locate the Finance profile in the Database DIT.

b Drag-and-drop Finance on your new rule in the Rule DIT.

c Locate the NewProducts database.

d Drag-and-drop the NewProducts database on your newly created rule.

Both Finance and the NewProducts database appear in the frame to the left of the tabs in the Properties pane when you click your new rule.

6 From the Rules menu, choose Filter > Enable. OR Right-click the filter in the Rules DIT to open a shortcut menu, and then choose Enable.

7 Save and activate your rule set. See b Saving and Activating a Rule Setb on page 195 to learn how.

Thanks in advance.

	<Prev	Next>		<<First	<Prev	Next>	Last>>