Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 11:55:27 GMT

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

Hi Srikanth,

Yes it's possible to switch the role. Also a user can have more than one role. But one role will be active at a time.

If we want switch the role in a session then user has to execute Set Role <Role-name> which will be active only for that session. If we want to have a default role for a user then we have to use modify user stmt to set default role option.

Thanks,

Praveen

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