Filter
Top Products
Describing the Query for iSeries query definition
You can also type some descriptive text about the query. The text reminds you what the query is for when
it is displayed in a list of queries or printed on the cover page of a report. The text is displayed, for
example, on the Work with Queries display whenever the Text column is shown.
Giving authority to others to your Query for iSeries query
You can specify the type of authority that you want to give to other users for this query definition object.
What you specify on the Exit This Query display determines how other users can use the query. When
saving a query after creating it, the default authority on the Exit This Query display is *LIBCRTAUT.
The values that you can specify are:
*LIBCRTAUT
Library create authority assigns the authority from the CRTAUT value in the library the object is
being created into. The authority could be *ALL, *CHANGE, *EXCLUDE, *USE, or an authorization list
name. The ability of other users to use the query file depends on the authority assigned.
*CHANGE
Change authority allows other users to perform all operations on the object except those limited to
the owner or controlled by object existence authority and object management authority. A user can
change or use the query definition in any way, except that it cannot be copied, deleted, or saved with
changes made to it.
*ALL
All authority allows other users to perform all operations on the object except those limited to the
owner or controlled by authorization list management rights. A user can do anything with the query
(including deleting it), except for transferring it to a new owner or changing the type of authority.
*EXCLUDE
Exclude authority prevents other users from doing anything with the query definition. Unless given
specific types of authority, no user except its owner can use the query definition.
*USE
Use authority allows other users to run the query or to display or print the query definition. A user
cannot copy the query definition nor save the definition with changes made to it. The query may be
selected for change and saved under a different name.
authorization list name
If you specify the name of an authorization list, its authority is used to control the access that users
have to the query. Query shows the public authority special value rather than the authorization list
name when the query is changed. You can specify an authorization list when you create a query; you
cannot put an authorization list on an existing query. For more information, see the iSeries Security
Reference book.
The following table shows, for each predefined type of authority, what can be done with the query.
Type of ’ Change Copy Delete Display Print Query Run Change
Authority ’ Query Query Query Query Definition Query Authority
--------- ’ ------ ----- ------ ------- ---------- ----- ---------
*ALL ’ Yes Yes Yes Yes Yes Yes No
*CHANGE ’ No No No Yes Yes Yes No
*USE ’ No No No Yes Yes Yes No
*EXCLUDE ’ No No No No No No No
Note: If the authority you specify is *LIBCRTAUT, the value assigned when the object was created is
used.
168 Query for iSeries Use V5R2
|
|
|