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.
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.