Archives of the TeradataForum

Message Posted: Wed, 23 Apr 2014 @ 21:27:12 GMT

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

Hi James,

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.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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