Privileges on Universe Tables

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Privileges on Universe Tables

Post by admin »

Hi all,

I am fairly new to universe database. Do we have role or groups in universe database to group sql users? I have a job that has a universe stage(the uv table has an undate action of clear the table, then insert rows. This works fine. But when a different user tries to run this job.It fails. Looks like for some reason it removes the required privileges on the table. When I grant select and delete privileges again, it runs fine with the second user. Can somebody help me. FYI - both the users are valid sql users in the database.

Thanks in advance.
Nilesh

____________________________________________________
Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm
Locked