 |
 |
Archives of the TeradataForum
Message Posted: Tue, 02 Jan 2007 @ 09:50:07 GMT
| Subj: | | Re: Question on Spool/Profiles |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | 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. | |
It depends on the release (V2R6+), within dipviews.bteq there's a comment:
DR95517-sh180008-01 05Jul21 DBC.Users shows Profile info
| | 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. | |
Just add an Outer Join to dbc.profileinfo, e.g.:
SELECT
COALESCE(p.SpoolSpace, u.SpoolSpace),
COALESCE(p.TempSpace, u.TempSpace),
...
FROM dbc.users AS u LEFT JOIN dbc.profileinfo p
ON u.ProfileName = p.ProfileName
Dieter
| |
