Version 126.96.36.1998 of Mumbai is available for download. Not too many changes and additions this time, but the fix for the positioning of sub-item on the custom button bar made me release it already. Here’s the list of changes:
- Added execute SQL/script on multiple connections functions in console window
This is a nice little timesaver when you need to execute a query or run a script on multiple databases. Instead of manually connecting to each database, you select “Execute query/script on multiple connections” and select the target databases in the next dialog.
Mumbai will connect to, query and disconnect from each selected database and show the combined result with a SOURCE column in a grid:
- Added “Cell multi select” option to grid popup menus (through the context menu of the column header)
Until now it was only possible to select whole rows in grids, which made it awkward to copy just one or a few columns to the clipboard. You can now switch to “Cell multi select” mode and select continuous cells and copy these to the clipboard.
- Added category field in connection management
- Added “Free MB of max” column in “Tablespace and datafiles” view
- Fixed refresh action in “Tablespace and datafiles” view
- Fixed positioning of sub-item on custom button bar
- Including CREATED and LAST_DDL_TIME columns in DBA_OBJECTS queries now
- Added “Convert to uppercase/lowercase” functions to context menu in console window
- Added “Users,Roles/privileges” view
This view shows all users, system and object privileges granted to users and roles granted to users, including other roles and privileges granted to this role.The USER_PRIVS column shows a tree-like indented structure, while the USER_PRIVS_PLAIN column shows the same info unindented, so that you can filter on privileges/roles (“Who has a privilege/role?”).
Though technically a role, PUBLIC is shown as a user and while all users have the privileges and roles assigned to PUBLIC, these are not shown below the users. So, if you would like to see all privileges a user has, you would need to filter for the username and ‘PUBLIC’ on the USERNAME column.