Privileges on Universe Tables
Posted: Tue Jul 03, 2001 2:50 pm
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
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