By Greg McGuffey - 1/25/2007
I just tried to create a view in the DDT based on a Union query. The view looks something like this:
Select Distinct
us_pk
,pm_id
,pm_key
,up_action
From SFSUserPermissionInfo
Union
Select Distinct
us_pk
,pm_id
,pm_key
,up_action
From SFSUserRolePermissionInfo
When I save it, it reports the following as the columns:
Column Table
----------------- --------------------------------------
pm_pk SFSPermissions
pm_pk SFSPermissions
pm_key SFSPermissions
pm_Key SFSPermissions
up_Action SFSUsersXPermissions
rp_Action SFSUsersXRoles
Distinct| us_pk SFSUserPermissionInfo| || Union
Distinct| us_pk SFSUserPermissionInfo| || Union
I deployed it and built a BO off of it and all seems to work, but the columns/tables are weird. I'm assuming that there are no significant ramifications of this, but I'd like to be sure all is OK.
|
By Trent L. Taylor - 1/26/2007
I am sure that it is fine. The view is deployed through SMO and at times the columns can be rearranged under certain circumstances. You should be fine.
|
|