TIMSS 6: More Ad-Hoc Query Security

It was pointed out to me that there is another way to add security to Ad-Hoc Queries. On the META001 screen where one sets up views for use with ad-hoc queries, there is an Available for Public check box. If you un-check this box, the Special Security button is activated, and you can select groups that can use this view for queries.

When a user goes to Ad-Hoc Queries they will only see queries that use views that they have access too. This is different from my previous post that puts security on the reporting category in Ad-Hoc Queries.

Applies to: TIMSS6