Issue 12664 - [RFE] allow to override table privileges as got from the system driver
Summary: [RFE] allow to override table privileges as got from the system driver
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 1.1 Beta2
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-26 12:03 UTC by Frank Schönheit
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2003-03-26 12:03:00 UTC
OOo's current philosophy regarding table privileges (i.e. the rights of the user
to do operations on tables such as INSERT, UPDATE, DELETE) is that the system
driver (i.e. the ODBC/JDBC driver provided by the database vendor) is asked for
these privileges, and that OOo's user interface disables any functionality which
the driver claims is not allowed.

There was a time where this approach seemed to work pretty well, but nowadays,
it's more and more common that database drivers to improperly implement the
getTablePrivileges, returning insufficient/incomplete/wrong information there.
Examples are MySQL (ODBC as well as JDBC), PostgreSQL, and Oracle.

We should have at least an option which allows to override this, and ignore the
privileges from the system driver. This option should be per-datasource (or
globally??), of boolean type, and, when set, cause the respective SDBC driver to
assume all privileges present. In such a case, OOo's UI would allow all
operations, but then present the possibly resulting errors to the user.

We should implement such a flag for at least the JDBC and the ODBC bridge.

FS->OJ: I suggest IgnoreSystemTablePrivileges, on a per-datasource basis. A user
interface for this is out-of-reach for 1.1, but we can do this later on, and for
the moment, handle this new setting like the ParameterNameSubstitution setting
(means it can be switched by using a Basic macro).
Comment 1 Frank Schönheit 2003-03-26 12:07:30 UTC
targeting
Comment 2 ocke.janssen 2003-03-26 17:39:09 UTC
Fixed in dba04
Comment 3 ocke.janssen 2003-04-03 13:18:02 UTC
Please verify. Thx.
Comment 4 marc.neumann 2003-04-09 14:02:56 UTC
.
Comment 5 marc.neumann 2003-04-09 14:03:11 UTC
.
Comment 6 marc.neumann 2003-05-20 09:17:19 UTC
Hi

this issue is fixed in OOo 1.1 Beta2 which is available at
http://www.openoffice.org/dev_docs/source/1.1beta2/.

I close this bug now.

Bye Marc

Comment 7 hans_werner67 2004-02-02 12:56:42 UTC
change subcomponent to 'none'