Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 11:31:43 GMT

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

Hi,

a user can have multiple roles, you may use this simple sql:

     grant role  to ;

Your current session can have only one role; you can change the current role with this sql:

     set role ;

Hope this helps,

Bye,

Francesca

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