Cannot grant sysproc function to user

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richard - 28 Apr 2005 16:00 GMT

DB2 UDB v8.1.5 on Windows
I want to grant some system function to user

DB2 GRANT EXECUTE ON FUNCTION "SYSPROC".SNAPSHOT_DATABASE(INTEGER,VARCHAR()) TO
USER

This is the error message I got.
DB21034E The command was processed as an SQL statement because it was not
a valid Command Line Processor command. During SQL processing it returned:
SQL0607N "GRANT OR REVOKE" is not defined for system objects.
SQLSTATE=42832

Is there some other ways to do this instead of add this user to the admin group?
Thanks

Reply to this Message

peteh - 28 Apr 2005 19:50 GMT

> Is there some other ways to do this instead of add this user to the
> admin group?

Try putting the user in the SYSMON group. This group was created
expressly for the purpose of monitoring (and using the snapshot table
functions) without giving them excessive priviledges.

Pete H

Reply to this Message