No access to the SNAPDYN_SQL view

[Damir]

Hello,
when I try to access the SYSIBMADM.SNAPD YN_SQL view:

select * from SYSIBMADM.SNAPD YN_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.SNAPD YN_SQL, and also
"execute" is granted to the public on the underlying function
SYSPROC.SNAP_GE T_DYN_SQL_V91.

Apart from that, user in question ("PPZ") is granted the DBADMAUTH authority
on the database.

Why the error?

Regards,
Damir

[Damir]

Re: No access to the SNAPDYN_SQL view


It requires the SYSMON authority?

Damir

[Serge Rielau]

Re: No access to the SNAPDYN_SQL view

Damir wrote:

It requires the SYSMON authority?

Yes I think so.



--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab