Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2011 @ 16:39:40 GMT

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

Try running the following on the user, after you grant the role to the user.

     MODIFY USER DB_USER AS DEFAULT ROLE = ALL;

Also, you may only want to use the suffix with admin option; for DBA users and not everyone.

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