Adding the results of a query to the security profile
Any query can be added to the security profile of an administrator. In this case it is not the query in itself but the result of the query that defines to which objects the administrator has access.
- Click Edit > Add Results of Query
.
The Select Dynamic Objects dialog box appears on the screen. The contents of the list box displays the dynamic objects either in the hierarchy of all queries or a list of all existing queries, depending on the icon you click in the left box. - In the drop-down box Object Type select the type of the database object to add.
This list is pre-filtered according to your licenses. - You can also search for a specific query via the Search tab.
- Click OK to confirm the selections.
The Properties dialog box appears to define the type of access for the queries. - Select the respective radio buttons.
The option Inherited is only of interest if you are defining this profile for an individual administrator instead of a group. In this case you can select this radio button if the access rights are to be inherited from the administrator group(s) the administrator belongs to. Check the option Respect Windows permissions when accessing files and the Registry in the Direct Access Acknowledgement panel if the access rights to the local files and the Windows Registry are to be restricted to those those of the local account. - Click OK to add the queries to the security profile.