MVSFORUMS.com

Kalyan Chandra · Posted: Tue Aug 30, 2005 6:06 am Post subject: Unload Authorization

How can I find the Authorization for Unloading a table for a individual user - Any way from sysibm tables.
_________________
Regards,
Kalyan..

kolusu · Posted: Tue Aug 30, 2005 6:30 am Post subject:

Kalyan Chandra,

There is no specific authority to unload a table. It all depends on whether you have the atuhority to run the unload utility plan(DSNTIAUL). This can be found in SYSIBM.SYSPLANAUTH table. You also need to authority to access the database which can be found in SYSIBM.SYSDBAUTH table

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Manas Biswal · Posted: Tue Aug 30, 2005 8:56 am Post subject:

And (in addition to what Kolusu has said), if you are unloading using the "UNLOAD" utility and not DSNTIAUL (UNLOAD is a new online utility which came with v7 - I think, versus DSNTIAUL which is a stand-a-lone utility), the authorizations on the tablespace should include one of the following -
Ownership of the tables
SELECT privilege on the tables
DBADM authority for the database
SYSADM authority
SYSCTRL authority

HTH....Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

Kalyan Chandra · Posted: Thu Sep 01, 2005 4:10 am Post subject:

Kolusu & Manas,

Thanks for information.

I will check the tables and get back with queries.
_________________
Regards,
Kalyan..