How can i check Load access on table?

IBM's flagship relational database management system

How can i check Load access on table?

Postby richagoyal » Wed Sep 14, 2011 12:49 pm

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 ?
Posts: 20
Joined: Thu May 27, 2010 11:45 am
Has thanked: 0 time
Been thanked: 0 time

Re: How can i check Load access on table?

Postby GuyC » Wed Sep 14, 2011 2:30 pm

select name, loadauth  from sysibm.sysdbauth

GRANT LOAD ON DATABASE <databasename> TO <userid>
I can explain it to you, but i can not understand it for you.
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2


  • Related topics
    Last post