By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Cannot grant sysproc function to user

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> 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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.