After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 78845 - Connections need to ability to be open in read-only mode
Connections need to ability to be open in read-only mode
Status: RESOLVED FIXED
Product: libgda
Classification: Other
Component: Server library
unspecified
Other Linux
: Normal normal
: GNOME-DB-1-0
Assigned To: Rodrigo Moya
Rodrigo Moya
Depends on:
Blocks: 78846 78847 78848
 
 
Reported: 2002-04-16 12:44 UTC by Rodrigo Moya
Modified: 2004-12-22 21:47 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Rodrigo Moya 2002-04-16 12:44:39 UTC 
For security reasons, such as in the Gnumeric GDA plugin, we need to open
connections in read-only mode, so that user-side SQL can't damage in any
way the connection being opened (think of a Gnumeric spreadsheet containing
a DROP ALL TABLES, for instance, if that exists).

So, we need to add this sort of option to the IDL and to each provider.
Comment 1 Rodrigo Moya 2003-01-10 01:21:19 UTC 
There is already a parameter in gda_client_open_connection with which
clients can specify the read-onlyness of connections to be opened.
Then, providers can check the gda_connection_get_options function to
determine if the connection is read-only or not. A simple way of
fixing this is in
providers/mysql/gda-mysql-provider.c!process_sql_commands.