Some free / open source softwares are available on the web for database design/administration. There are two of them which are available as free download : MySQL Workbench and Open ModelSphere.
They can be installed on Windows or Linux platforms. MySQL Workbench was formely known as DB Designer. With the latest release of MySQL Workbench (ex-DB Designer 4), only the oldest versions of DB Designer are available on download.
For more information :
If your are connected as root on your MySQL database, you can list all the system and object privileges for a given user :
mysql> show grants for user ‘fool’@'localhost’;
or if you are connected as the user fool :
mysql> show grants;
mysql> show grants for current_user;
mysql> show grants for current_user();
current_user function is available if your MySQL version is equal or higher that 5.0
If monitoring Oracle databases is part of your job, then some supervision programs need Oracle sqlplus command-line to access remote databases and perform some health status checks.
In order to have it on your systems, just download Oracle instant client. It is available on many platforms (Windows 32 and x64, Linux x86 and x86-64, AIX) and free of charge.You can download it as a rpm file or zip one according to your needs. To proceed the download, an Oracle account is required. The subscription is free and very easy to do.
Oracle instant client download page
More information about Oracle instant client :
