Hello,
when I try to access the SYSIBMADM.SNAPDYN_SQL view:
select * from SYSIBMADM.SNAPDYN_SQL where stmt_text like '%SKUP_PR%';
I get the SQL error:
(-1092)[IBM][CLI Driver][DB2/AIX64] SQL1092N "PPZ " does not have
the authority to perform the requested command.
even though "select" is granted to the public on the view
SYSIBMADM.SNAPDYN_SQL, and also
"execute" is granted to the public on the underlying function
SYSPROC.SNAP_GET_DYN_SQL_V91.
Apart from that, user in question ("PPZ") is granted the DBADMAUTH authority
on the database.
Why the error?
Regards,
Damir