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

[Vivien Malerba <vmalerba gmail com>]

On 20 May 2010 13:52, Murray Cumming <murrayc murrayc com> wrote:
> Is there any way to use GdaSQlBuilder to do thinks like this, which Glom
> does with PostgreSQL?:
>
> ALTER USER "bob" PASSWORD "secret"
> CREATE USER "bob" PASSWORD "secret"
> DROP USER
> REVOKE ALL PRIVILEGES ON "invoices" FROM "bob"

No. For this kind of statement (other than SELECT, UPDATE, INSERT or
DELETE) you can either directly use SQL or use the GdaServerOperation
(though at the moment the GdaServerOperation does not support doing
any user manipulation, and it should be added, tell me if you would
like to have this in the 4.2).

Of course using a GdaServerOperation is cleaner and more portable than
using SQL.

Vivien