The SYSMON group privileges cannot be encapsulated.
You will need to make the users part of that group.
See this link:
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin/c0011397.htm?resultof=%22%53%59%53%4d%4f%4e%22%20%22%73%79%73%6d%6f%6e%22%20


Cheers
Serge


"Divakaran Anuja R "
<db2udbdba-ezmlmshield-x2005687.[Email address protected] wrote on
10/24/2005 01:59:01 AM:

> 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
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


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