Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 16:37:10 GMT

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

There have already been a few good points raised here (Backup considerations and AccessRights ... a big one.) as well as some alternative suggestions.

One additional note I would make is that it takes a few seconds to create a user ... so creating 750,000 will take quite a while. You will want to ensure that each 'batch' falls within a 'quiet' period on your system since Create User will place a lot of dictionary locks that you dont want to see during heavy processing windows.

If you are on 5.0 I would definately look into using Roles and Profiles.

Grant all required rights only to the roles - none on the users. (Profiles help with management of the users rather than access rights.)

Also issue a 'Revoke All on <user> from <user>, <creator>' to remove all the rights that were automatically inserted into the accessrights table.

These steps will dramatically reduce the size of your accessrights table.

Finally, either use some kind of script generator to create the 'Create User' scripts ... or use the SQL Assistant 'Import' mode. (Issue the statement

Create User ? from <owner> as perm=0 password = ?

and point it to a file containing a delimited text file with 2 columns for username and password. If your names are generic such as AAA00001, AAA00002, you can quickly create the file using Excel's autofill feature. If they are not generic you must have them in a table/file somewhere already.)

Mike Dempsey
Teradata Client Tools

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