Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2004 @ 17:24:39 GMT

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

<-- Anonymously Posted: Wednesday, February 11, 2004 12:18 -->

Hi,

Can someone please clarify assigning a role to a role..?

Say there are two roles, A and B.

A has SELECT access to table_a
B has SELECT access to table_b

Say user P has been given role A
and user Q has been given role B

If I GRANT role A to role B, what happens ?

What accesses would user P and Q now have ?

Thanks

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