[JPV]

Sorry, haven't been here for a while… I guess the notification for new replies didn't work…

Quote:

1)

there are quite a lot of new privileges wiht the MySQL-server ver. 5. They should be included too!

2)

It should also show “resources” available to user (# of simultaneous connections etc. )

Of course… my design is a design for a new structure, not a design to mention all existing permissions; extra user properties can be added, of course!

Quote:

“ALL” privilges should be shown at left and be applicable for as well “global privileges”. “Schema privileges”, “table privileges” and “column privileges”. To make it ease to GRANT all available privileges of a table to a certain user.

I agree completely…

Quote:

And privileges that are not applicable with a certain server version should either “grey out” or be hidden.

I think they should be hidden; grey them out when the user has no permission to change a prvilege.

Quote:

The window looks quite similar to our current Manage Permissions option. I think in the above design, @jpv proposes to show tables of the highlighted DB.

Quote:

I'd consider an ability to “unfold” a DB to show tables below it and “unfold” a table to show columns accordingly.

This will require a TREEVIEW control like ObjectBrowser rather then GRID control approach that we are using

Indeed I propose to show tables of the highighted DB and columns of the highlighted table. In my design I do not want to show a complete overview of all permission settings; in the first place I want one single place to grant/revoke permissions and view existing permissions; two different windows is terrible if you need them both at the same time. On the other hand, a treeview like design leaves it to the user what he wants to see and what he wants to hide; even in my design it can be difficult to compare permissions, especially when comparing column permissions in different databases. In my opinion the treeview will be the best solution, for it can show the things the user wants to see and can hide the things that the user doesn't want to see.

Quote:

There is one thing more to consider. I believe a user can only GRANT a priviliege to otheres if he has the privilege himself. Right ? Privileges that are not GRANTable for current user could also be shown in another symbol or color (example: red cross over box).

I prefer greying out the permissions that cannot be set by the user; a red cross can be confusing: in SQL Server Enterprise Manager, for example, it means a revoke…

Quote:

It should be able to set miscelaneous information (Full name, Description, Email, Contact Information)about the user (Table “user_info” i the “mysql” D:cool:

same as above: extra user properties can be added, of course!

[JPV]

Sorry, haven't been here for a while… I guess the notification for new replies didn't work…

Good question… Of course the tables should be of the source database. But you don't know what the source database will be until you press one of the copy buttons… and that's too late. Perhaps it is possible to make database 1 the source and database 2 the destination, with one copy button (from left to right, of course) and have an extra button that switches the source and the destination, and that will reload the tables list.

[JPV]

I posted my design earlier but apparently it did not appear in the forum, so now I try it again. The design is for a window with easier database copying, without confusion about source and target. Consider this to be a first sketch and I am curious about your response!

[JPV]

Hello,

Sorry it did take so long before I posted my proposal, but here it is. In my opinion it is one window that combines three of the current windows: 'Add User', 'Edit User' and 'Manage Permissions'. Consider it to be the first sketch and don't hesitate to make comments. I am curious about your opinion!

[JPV]

Hi,

I am very busy at the moment, but I will try to post a form design as soon as possible. I hope within a few days.

[JPV]

Hello,

I am creating some sample forms at the moment, but because I'm very busy it can take some more days. At least I want to mention that I am glad that you are willing to consider my suggestion and that I'm working on it.

Thanks and soon I will post my sample forms…

[Author]

Posts