Hi, Please comment on this wish list for the new User management page:
- rename it "Users" instead of "Privileges"
- (later) split list of users in "User overview" on multiple pages, based on $cfg['MaxRows'], with navigation << < > >>
- (already asked to Alexander) in the "remove selected users" dialog, add an option to delete the db which has the same name as the user
- 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
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
But I am not sure if the batch mecanism should be on the same page.
Of course, we need some validation to avoid creating databases that already exist.
Marc Delisle
Marc Delisle wrote:
Hi, Please comment on this wish list for the new User management page:
rename it "Users" instead of "Privileges"
(later) split list of users in "User overview" on multiple pages,
based on $cfg['MaxRows'], with navigation << < > >>
- (already asked to Alexander) in the "remove selected users" dialog,
add an option to delete the db which has the same name as the user
- 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
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
But I am not sure if the batch mecanism should be on the same page.
Of course, we need some validation to avoid creating databases that already exist.
Marc Delisle
- Sort the user list by user name.
Marc
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 Johnson wrote:
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'
OK for me. Should we use also the last field as the db prefix for the case when we create only the privilege, not the db? 'user1', 'host1', 'pwd1', 'db1%'
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.
Agreed.
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.
OK
Marc
-----Original Message----- From: phpmyadmin-devel-admin@lists.sourceforge.net
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.
imho, the order of the values can easily be made configurable for the user. All of the fields could be left out, theoretically:
- If the usernames are not specified, phpMyAdmin could generate usernames using a prefix given by the user (user_0001, user_0002, user_0003, etc.). - If the hosts are not specified, a predefined host, e.g. '%' or 'localhost', is used for each user. - If the passwords are not included in the file, they could either be left blank or phpMyAdmin could generate random ones.
Regards,
Alexander
-
Marc Delisle -
Rabus -
Robin Johnson