Hi Monica
List tablespaces requires a minimum of load authority or membership of the
SYSMAINT or SYSCTRL groups - much too dangerous for most developers in a
production environment! I know - I used to be one. If the system catalog
tables - principally syscat.tablespaces - do not give the developer what he
needs, then one workround is to compile the corresponding API call and make
the execute bit a 'sticky' to group 'other'. Give this as a task to your
developer, particularly if he can't speak C, that should keep him quiet for
a while.
It's the assumption behind the question that is curious - why would a
developer want such information in a production environment and to what
purpose would he put it? Looks a bit dodgy to me ...
Regards
Alex

-----Original Message-----
From: Strubel Monica [LTD]
[mailto:db2udbdba-ezmlmshield-x59222217.[Email address protected]
Sent: 24 July 2006 22:42
To: LazyDBA Discussion
Subject: System tables behind 'list tablespaces show detail'

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




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection



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