Page 1 of 1

How can i check Load access on table?

PostPosted: Wed Sep 14, 2011 12:49 pm
by richagoyal
Hi,
I want load data in a table. I am able to insert, update and delete data but when I am trying to load data into table its is saying "user NOT AUTHORIZED FOR LOAD UTILITY ON DATABASE " .
How can I check load access in table ? I don't have authorization to see data in table SYSIBM.SYSUSERAUTH .
we have authority to do grant select on table to user , but I tried with grant load on table to user it is giving me error saying not valid command .
Please suggest how can I see load authority on DB ?

Re: How can i check Load access on table?

PostPosted: Wed Sep 14, 2011 2:30 pm
by GuyC
select name, loadauth  from sysibm.sysdbauth

GRANT LOAD ON DATABASE <databasename> TO <userid>