Thanks Hermann, This information is useful. I think we should wait for the first alpha version of 1.7.2 that includes support for getTablePriviledges. You can then start the tests and we'll make the necessary improvements to get it to work. This support could be available in a few weeks' time.
Fred Toussi --------------------------------------- Herman Kienlein wrote: > Support for getTablePriviledges should be available in version 1.7.2. Would > you be able to do a bit more work on this and tell us: > > Which users are the issue? Hope I understand your question right :-) OOo looks on the database wether write-privileges are enabled for every table which is in the database. so for every table should come a record in the way tablename grantor grantee rights etc. as described in the jdbc-specs, the table SYSTEM_TABLEPRIVILEGS is right to do this, but if I create a user he should be in this table, and if I grant rights, every right should be as a single record, not only FULL (or simple getTablePrivileges should split this up) > > Is OpenOffice creating the users and then checking the privileges to allow > access? by now, OOo only checks the privileges, create users is only implemented for ADABAS, but I think, if hsqldb works well it should be possible to do this also, because the UI excists for doing this. the way OOo checks the connection to a database is so (Info from Ocke / Developer of the Database-Code in OOo) <quote> I'll list the things we do below, addtitional I'll attach the used code. - check how many tables are involed - check if the used table has a primary key - check if all primary key columns are in the select clause ( bAllKeysFound ) - check if the ResultSet be use supports bookmarks - if not we need a KeySet ( bNeedKeySet ) when using a KeySet - check if there is any column which doesn't support NULL values which isn't in the select clause ( remove the INSERT privilege ) - check the privileges of the table - if an Exception occurs, use the StaticSet </quote> PS: I could do some work/help on the jdbc-Implementation, if you need help, but to write inside in hsqldb, I think its a too great job for me. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
