Thanks Hermann,
The work on user-rights reporting has progressed and will hopefully be
release in a new ALPHA package in a week's time. The new version will report
all the rights for each user.
We certainly want to support OOo (OpenOffice.org) and other software that
needs better metadata reporting.
Fred
----- Original Message -----
From: "Hermann Kienlein" <[EMAIL PROTECTED]>
To: "hsqldb-developers" <[EMAIL PROTECTED]>
Sent: 20 January 2003 19:24
Subject: [Hsqldb-developers] HSQLDB with OpenOffice.org
Hi Fred, *,
I work still on getting hsqldb working with OOo and have still some
problems :-(
please can someone do some small modifications to get this working
until a new user-concept or something else is ready?
(I don´t want publish a patched version on hsqldb for tryout)
If I do some minimal changes, I can work with OOo. I do this only
for the user sa, but OOo needs first a single-user DB, and than it
is not so stromg, wether someone takes sa or something else as
user-name.
so I have done:
in:
DatabaseInformation:getSystemTable
case: SYSTEM_TABLEPRIVILEGES
for (int i = 0, tSize = tTable.size(); i < tSize;
i++) {
Table table = (Table) tTable.get(i);
if (table.tableType == Table.TEMP_TABLE
|| table.tableType ==
Table.TEMP_TEXT_TABLE) {
if (dDatabase.findUserTable(
table.getName().name, session) ==
null) {
continue;
}
}
// hkienlein, give some simple rights back for
user sa
String[] sRights = new String[]
{"SELECT","UPDATE","DELETE","INSERT"};
for (int i1 = 0; i1 < 4; i1++) {
Object o[] = t.getNewRow();
o[0] = o[1] = "";
o[2] = table.getName().name;
o[3] = "sa";
o[4] = "sa";
o[5] = sRights[i1];
t.insert(o, null);
}
}
return t;
because ALL is not a valid JDBC-Right.
in:
jdbcDataBaseMetaData:supportsCoreSQLGrammar
I give back: true
(I don´t no what CoreSQLGrammar is, so can you tell me, what is not
implemented with hsqldb?)
This are the first things, next come with IDENTITY and getTypes (I
hope in near future, if I find some time)
BTW:
Are you interested in some hints to get OOo working with your DB?
Should I post on this list or to another one?
--
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: FREE SSL Guide from Thawte
are you planning your Web Server Security? Click here to get a FREE
Thawte SSL guide and find the answers to all your SSL security issues.
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
-------------------------------------------------------
This SF.NET email is sponsored by: FREE SSL Guide from Thawte
are you planning your Web Server Security? Click here to get a FREE
Thawte SSL guide and find the answers to all your SSL security issues.
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
