Hi fredt, thanks for answer,
fredt schrieb: > It would definitely be a good idea to support OpenOffice. > the correct name is OpenOffice.org or simple OOo because the rights for OpenOffice are by somebody else. > 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. -- mfg Hermann Kienlein ------------------------------------------------------------------- EDV-Systeme Kienlein GdbR FON: +49-9184-80040 Pfarrer-Zinckel-Str. 10 FAX: +49-9184-80041 D-92364 Deining http://www.kienlein.com ------------------------------------------------------- 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
