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.

Authorization: None required.

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

The result of the function is a SMALLINT.

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