Use the following,

select 'Grant Select, Update, Insert, Delete on <SCHEMA>.'||tabname||'
To user <USERNAME>' from syscat.tables where tabschema = '<SCHEMA>';
Select 'Grant Execute on Procedure <SCHEMA>.'||procname||' To user
<USERNAME>' from syscat.procedures where procschema = '<SCHEMA>'; Select
'Grant Execute on Function <SCHEMA>.'||Funcname||' To user <USERNAME>'
from syscat.Functions where funcschema = '<SCHEMA>';


Replace <SCHEMA> and <USERNAME> and run each of the queries to get the
grant statements for each type of object.


Regards,



-----Original Message-----
From: pavan
[mailto:db2udbdba-ezmlmshield-x40419095.[Email address protected]
Sent: Friday, July 28, 2006 9:04 PM
To: LazyDBA Discussion
Subject: insert/update/select/delete on large no. of tables





all,
how can i grant Insert/update/delete/select permissions on all tables
in a database to a group without going through individual table names
and without grunt work of assigning insert, update, delete etc on each
statement.

Thanks and Best regards.
Pavan.

Thanks and Best regards.
Pavan Kristipati
Prudential Retirement
Phone: 1-732-482-8883
Email: pavan.[Email address protected]



---------------------------------------------------------------------
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