The QUERYAUTH option specifies the administrative authority level required to issue QUERY or SQL SELECT commands. By default any administrator can issue QUERY and SELECT commands. You can use this option to restrict the use of these commands.
Syntax
>>-QUERYAuth--+-NOne-----+------------------------------------->< +-SYstem---+ +-POlicy---+ +-STorage--+ '-OPerator-'
Parameters
- NOne
- Any administrator can issue QUERY or SELECT commands without requiring any administrative authority.
- SYstem
- Administrators must have SYSTEM authority to issue QUERY or SELECT commands.
- POlicy
- Administrators must have POLICY authority over one or more policy domains or SYSTEM authority to issue QUERY or SELECT commands.
- STorage
- Administrators must have STORAGE authority over one or more storage pools or SYSTEM authority to issue QUERY or SELECT commands.
- OPerator
- Administrators must have OPERATOR or SYSTEM authority to issue QUERY or SELECT commands.
Examples
To restrict the use of QUERY and SELECT commands to administrators with system or storage authority, enter:
queryauth storage