468,249 Members | 1,487 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

Cannot grant sysproc function to user

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
1 3947
> 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.

Similar topics

reply views Thread by Charles Cantrell | last post: by
reply views Thread by Jean-Marc Blaise | last post: by
4 posts views Thread by Andy S. | last post: by
5 posts views Thread by Grant | last post: by
3 posts views Thread by Chris Ochs | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.