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 82679 - GRANT/REVOKE API
GRANT/REVOKE API
Status: RESOLVED OBSOLETE
Product: libgda
Classification: Other
Component: Client library
0.8.x
Other Linux
: Normal enhancement
: ---
Assigned To: malerba
gnome-db Maintainers
Depends on:
Blocks:
 
 
Reported: 2002-05-23 00:07 UTC by Rodrigo Moya
Modified: 2018-09-21 13:38 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Rodrigo Moya 2002-05-23 00:07:22 UTC 
We need a API for clients to be able to GRANT/REVOKE rights on DB objects.
This API should be flexible enough for managing as many scenarios as possible.

So far, here are the thoughts:

> > 
> > > - we need to allow the application to know what options the provider
> > > accepts to adapt the GUI to what is available only
> > >
> > ok, that is perfectly doable. What are the options you're thinking
> > about?
> 
> Several options:
> - types of rights (read, insert, update, or read, write, etc);
> - if rights are managed at the level of a database, a table or some
> columns of a table, sequence, index, vues...
> - the kind of rights for a user (create DBs, create other users, change
> passwords of other users, etc).
> - maybe other ones.
>
Comment 1 malerba 2007-09-27 09:50:26 UTC 
Grant/Revoke operations should be possible using the GdaServerOperation object. Just add a declaration for that type of operation, for each operation, create the spec file specifying all the input required for the operation, and add the code to the providers.

An analysis work must be performed to define type of operations correctly to have the same maening across providers, for example I think there should be separated operations to grant privileges on tables, databases, functions, languages, schemas, tablespaces, etc.
Comment 2 GNOME Infrastructure Team 2018-09-21 13:38:04 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/libgda/issues/36.