Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2012 @ 22:14:44 GMT

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

If the user has Default Role = All, then granting a new role to a user will make those role rights active at next logon.

Otherwise the user would have to execute a SET ROLE statement.

You can also modify the user to have a specific role as Default, but based on your question that probably doesn't fit your security model.

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