On 19 June 2010 21:11, Murray Cumming <[email protected]> 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 _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
