On Tue, Jan 07, 2003 at 08:41:00AM -0500, Marc Delisle wrote:
- A new batch user and db creation mecanism. Starting from a local file like this: user1, password1 user2, password2 user3, password3 ...
we could upload this file. There would be a radio button: () just create users () create users and generate a db named after the user () create users and generate a privilege that enables users to create their dbs, with the username as a prefix extend the format slightly user1, host1, pwd1, db1 user2, host2, pwd2, db2
and the "generate a db named after the user" can instead use the specified dbname if given, else it can use the username as the dbname. I think the file should have quotes in it, since space and comma characters could be found in usernames/passwords/dbnames. so: 'user1', 'host1', 'pwd1', 'db1' 'user2', 'host2', 'pwd2', 'db2' maybe swap the order of host and password for easier use. data like this can be generated in Excel easily as CSV format with quotes.
On the "Add a new user" new page, there are some dialogs that could be used also for the batch: - the host - the global privileges Just abstract them to a function so that we can display identical dialogues on both the creation page and the batch page.
But I am not sure if the batch mecanism should be on the same page. I think the batch stuff should definetly be on a sepearate page, as it could get very confusing for some people.
Of course, we need some validation to avoid creating databases that already exist. Display an error if the username or db already exists and continue with the rest of the data.
-- Robin Hugh Johnson E-Mail : robbat2@orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639 GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85