Hi,

I have a developer who does not have permission to submit 'list tablespaces show detail' to a Prod database.

1) Is there a 'grant' statement (or whatever other means) that I can grant him to allow him only this command?
2) What system tables/views can I have him query for him to get the following info on a tablespace:

Total pages
Useable pages
Used pages
Free pages

Thank you.

Monica



DB2 & UDB email list listserv db2-l LazyDBA home page