Archives of the TeradataForum
Message Posted: Wed, 23 Apr 2014 @ 21:27:12 GMT
By default, the user can only select from DB1 and DB2 (which are granted via the user's default role).
If Role B is a child of Role A or if the user issues 'set role = all' then they will be able to select from all four db's.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|