IBM SC41-5210-04 manual Describing the Query for iSeries query definition

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.

168Query for iSeries Use V5R2