Archives of the TeradataForum
Message Posted: Fri, 15 Jan 2010 @ 12:50:32 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|