Archives of the TeradataForum

Message Posted: Fri, 29 Dec 2006 @ 14:28:25 GMT

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

<-- Anonymously Posted: Friday, December 29, 2006 09:22 -->

Hello All,

If I create a user and give him spool of 10GB, then add him to a Profile that has a different Account ID and spool size. The manual states that the user will show up with that Profile's account string and use that amount of spool.

Is there a query that will display this for the user? If I do a select * from dbc.users, it will show me the 10GB and the original account string.

Thanks and Happy New Year

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