Hello:

When I ran the following SQL Statement from a non-SYSADM user, I
getting SQL0443N errors.

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------
-----------
SQL0443N  Routine "SYSPROC.SNAPSHOT_LOCK" (specific name
"SNAPSHOT_LOCK") has
returned an error SQLSTATE with diagnostic text "".  SQLSTATE=38553

However, when I ran the same as a instance owner, it runs fine:

select table_name from table(snapshot_lock(' ', -1)) snapshot where
table_name is not null order by table_name

TABLE_NAME

---------------------------------------------------------------------------------------------------------------------

 0 record(s) selected.

Any insights greately appreciated.

Thanks
Sarvesh