GRANT DROP priviledges to other users on localuv tables
Posted: Wed Jul 05, 2006 10:11 am
*****FileSjob..XFORM_MERGE: |*****FileSjob..UV_MERGED_FILE.inMerge: DSD.BCIOpenW call to SQLExecDirect failed.
DROP TABLE "Hsh_ECRM_CON_ACCT"
SQLSTATE=42000, DBMS.CODE=950563
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: You don't have enough privileges to DROP "Hsh_ECRM_CON_ACCT".|
I am getting the above error when I try to rerun a Job, that was initially run by my colleague.
This job basically tries to use the Universe database to host merged data and help with partially selecting different columns to feed different tables. This Job runs fine when run by my colleague.
The error, I believe, occurs as the Table/file was created by my colleague and I don't have drop priviledges to access this file.
I even tried setting the DATA.30 and OVER.30 of the Hsh_ECRM_CON_ACCT file to chmode 777.
Please help me with how I can, as a part of the DDL grant priviledges on the table being created to the group or list of users.
Thank you,
a Novice
The question is
DROP TABLE "Hsh_ECRM_CON_ACCT"
SQLSTATE=42000, DBMS.CODE=950563
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: You don't have enough privileges to DROP "Hsh_ECRM_CON_ACCT".|
I am getting the above error when I try to rerun a Job, that was initially run by my colleague.
This job basically tries to use the Universe database to host merged data and help with partially selecting different columns to feed different tables. This Job runs fine when run by my colleague.
The error, I believe, occurs as the Table/file was created by my colleague and I don't have drop priviledges to access this file.
I even tried setting the DATA.30 and OVER.30 of the Hsh_ECRM_CON_ACCT file to chmode 777.
Please help me with how I can, as a part of the DDL grant priviledges on the table being created to the group or list of users.
Thank you,
a Novice
The question is