Archives of the TeradataForum

Message Posted: Fri, 14 May 2004 @ 15:02:43 GMT

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

You will need DROP USER privilages on each user if you plan to adjust the Spool space of each one individually.

A better approach (if you are using V2R5) is to create a Profile with the required Spool Space allocation and then assign this profile to all the users.

This will allow you to alter the Spool Space (or various other fields) of all these users in one statement in the future.

(The profile would essentially replace your 'group user' for most things. If you allocate Access rights using the 'ALL groupuser' syntax you would also need to create a Role for these users...which woul dbe more efficient as well as easier to maintain.)

Note that if you are still using V2R4 and therefore need to issue the GRANT statement for a large number of users you can use the Import feature of SQL Assistant to do this very easily.

Simply use the statement

GRANT DROP USER ON ? TO myself

(where 'myself' is your userid)

And when it asks for the Import file simply point it to a file containing the names of the users you need the rights on. (One name per line. You can generate this file using an Export of a simple select statement to select all users owned by the 'group user'. [You will need to remove the first line of the export file - the column header - before using it as an import file.])

Mike Dempsey
Teradata Client Tools

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