jdbcDriverOOo 1.3.1

[psilocybe]

Hi all,

I am announcing the new version of jdbcDriverOOo 1.3.1.

This new version still manages 7 different databases natively, which are:
- SQLite
- HsqlDB
- H2
- Derby
- Firebird
- MariaDB
- PostgreSQL

But in addition to the functions normally supported by Base, this new version will allow you:
- To rename the tables.
- To rename the views.
- To rename the columns of a table.
- To edit a view in SQL mode.
- To move a table.
- To move a view.
- To create primary keys at posteriori (while retaining the data).
- To create foreign keys between tables located in different catalogs and/or schemas.
- To change the type of a column in a table (while retaining the data).
- To assign comments to a column of a table.
- To authorize the use of Bookmarks (possibility of editing tables even in the absence of a primary key)
- To prohibit the use of Bookmarks.
- To display the system tables.
- To hide system tables.
- To choose the level of the UNO API that the driver presents to Base (sdbc, sdbcx or sdb)
- To easily update the Java .jar archive of the underlying driver.
- To be able to access the logging of the underlying Java driver (if it supports it).
- To create users.
- To create roles (groups).
- To delete users.
- To delete roles.
- To change a user's password.
- To assign roles to a user.
- To assign roles to a role.
- To delete a role from a user.
- To delete a role from a role.
- To see the privileges of a user on a table or a view.
- To see the privileges of a role on a table or a view.
- To see the privileges inherited of a user on a table or view.
- To see the privileges inherited of a role on a table or a view.
- To assign privileges to a user on a table or a view.
- To remove privileges from a user on a table or a view.
- To assign privileges to a role on a table or a view.
- To remove privileges from a role on a table or view.

Welcome to the 21st century, we were only 23 years old and a little over 3 months late... and happy use...