Re: [gnome-db] "ALTER USER", etc, with GdaSqlBuilder?

[Vivien Malerba <vmalerba gmail com>]

On 19 June 2010 21:11, Murray Cumming <murrayc murrayc com> wrote:
> On Thu, 2010-05-20 at 22:48 +0200, Vivien Malerba wrote:
>> Here is a patch implementing the CREATE USER operation for PostgreSQL
>> (done in 30'). If you find it usefull I'll add the other operations
>> for users as well before a 4.1.6. You can test it with the
>> libgda-ui/demos/gdaui-demo-4.0 and the "DDL queries" demo item.
>
> This seems to just support the equivalent (in PostgreSQL) of
>  CREATE USER someusername
> but for Glom I need
>  CREATE USER someusername "PASSWORD" 'somepassword'
> (well that's the weird quoting that I find in my Glom code right now.)
> and

These (along with the DROP USER) should now wotk with the latest
commits in master. If it's OK with you I'll make a 4.1.7 tonight.

>  CREATE USER someusername PASSWORD somepassword SUPERUSER CREATEDB
> CREATEROLE
>
>
> I also use:
>  DROP USER someuser
>  ALTER GROUP somegroup ADD USER someuser
>  ALTER GROUP somegroup DROP USER someuser
>  REVOKE ALL PRIVILEGES ON sometable FROM someuser
>  GRANT ALL PRIVILEGES ON sometable TO GROUP
>  GRANT SELECT UPDATE INSERT DELETE ON sometable TO GROUP
>  (sometimes omitting some of SELECT, UPDATE, INSERT, or DELETE)
>  (or REVOKE .. FROM versions of the GRANTS)

Managing user rights is a bit tricky, and I preder to study a bit more
about how the other databases do it before I propose something.

>
> (Note that USER and GROUP are "obsolete" now in PostgreSQL, replaced by
> ROLE:
> http://www.postgresql.org/docs/8.4/static/sql-altergroup.html
> But I _guess_ that USER and GROUP are probably still the generic
> concepts shared by other database servers.)

This is now handled correctly in master.

Regards,

Vivien