Archives of the TeradataForum

Message Posted: Fri, 15 Jan 2010 @ 12:50:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

We have a prod system and our sister org has a system of their own. We want to merge their environment (data and users) with the contents of our system. Data isn't the problem, but consolidating users and accessrights has presented a challenge. Has anyone done this, what worked and what challenges did you have. Any hiccups?

We need to grant at a table level not a database level. We dont use roles (as yet its a down the line thing) so the accessrights table is quiet big.

I've thought of spliting the table based on the col grantauthority and from there breaking out the accessrights and appending the sql but that seems very long winded. If this was your task, how would you do it?

I'd appreicate any info or assitance

thanks

anne

	<Prev	Next>		<<First	<Prev	Next>	Last>>