SQL_CHECK_AUTHORITY scalar function

The SQL_CHECK_AUTHORITY scalar function returns an indication of whether the user is authorized to query the specified *FILE object.

Read syntax diagramSkip visual syntax diagramSQL_CHECK_AUTHORITY(library-name ,file-name)
The schema is QSYS2.
Library name containing the file.
File name for which authority will be examined.

The result of the function is a SMALLINT.

The returned value is:
If the user does not have authority to query the file, the object is not a *FILE object, or the object does not exist.
If the user is authorized to query the file.