Users who have User Query Admin security permission can run almost any User Queries (both released and non-released), and add, edit, and delete queries.
- To also run command queries, user must also have the Command Query permission.
- If using Random Primary Keys / Slave Monitor, queries with CREATE TABLE or DROP TABLE syntax can only run on the computer named as the User Query Server on the Replication Setup window (Replication).
To access query options, in the Main Menu, click Reports, User Query.
- See Query Window for a description of all options on the Query window.
- See Query Favorites for instructions on running, adding, and editing query favorites, including how to mark queries as released.