Hi,
I have created a normal user. I want to give permissions to this
user for executing some queries which use table functions and
procedures. I gave execute permissions for these to the user. I use ODBC
for querying.

Now Execute returns me SQL_SUCCESS. But when I try to do a fetch, i get
error. Following are the statements that I try to execute with this user
and the error that I get.

Does anyone know what all privileges that I should grant this user so
that my query execution does not fail and i get results

CAPTURE STORAGE MANAGEMENT INFO
---------------------------------
call sysproc.capture_storagemgmt_info(0,'','SAMPLE')

szSqlState = "38553",
MessageText = "[IBM][CLI Driver][DB2/NT] SQL0443N Routine "*GMT_INFO"
(specific name "") has returned an error SQLSTATE with diagnostic text
"SQL1092 Reason code or token: MANJU ".
SQLSTATE=38553

SNAPSOT_DATABASE
------------------
SELECT * from table(snapshot_database('',-2)) as x

szSqlState = "38553",
szErrorMsg = "[IBM][CLI Driver][DB2/NT] SQL0443N Routine
"SYSPROC.SNAPSHOT_DATABASE" (specific name "SNAPSHOT_DATABASE") has
returned an error SQLSTATE with diagnostic text "".
SQLSTATE=38553


SNAPSHOT_TBS_CFG
--------------------
SELECT * from table(sysproc.snapshot_tbs_cfg('',-2)) as x

szSqlState = "38553",
szErrorMsg = "[IBM][CLI Driver][DB2/NT] SQL0443N Routine
"SYSPROC.SNAPSHOT_TBS_CFG" (specific name "SNAPSHOT_TBS_CFG") has
returned an error SQLSTATE with diagnostic text "".
SQLSTATE=38553

CONTAINER
----------

select * from table(snapshot_container('',0)) as x


szSqlState = "38553",
szErrorMsg = "[IBM][CLI Driver][DB2/NT] SQL0443N Routine
"SYSPROC.SNAPSHOT_CONTAINER" (specific name "SNAPSHOT_CONTAINER") has
returned an error SQLSTATE with diagnostic text "".
SQLSTATE=38553


Thanks in advance for all help
Regards
Anuja Rani D

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