> You can find some plpgsql functions here:
>
> http://pgedit.com/tip/postgresql/access_control_functions
John, thank you.
I found that acl_admin.grant_on_all() does not grant privileges on schema:
it does not execute
GRANT ALL ON SCHEMA myschema TO myrole;
statements.
So I must execute GRAN
/8.1/interactive/lo-funcs.html
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de John DeSoi
Envoyé : mercredi 18 janvier 2006 15:43
À : Richard Huxton
Cc : Andrus; pgsql-general@postgresql.org
Objet : Re: [GENERAL] Change owner of all database objects
O
-funcs.html
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de John DeSoi
Envoyé : mercredi 18 janvier 2006 15:43
À : Richard Huxton
Cc : Andrus; pgsql-general@postgresql.org
Objet : Re: [GENERAL] Change owner of all database objects
On Jan 18, 2006, at
On Jan 18, 2006, at 4:02 AM, Richard Huxton wrote:
Andrus wrote:
Currently all my database objects are owned by superuser postgres .
I need to change owner to a nonprivileged role for all objects in
a database.
I'm using Postgres 8.1 server and client in Windows XP, only
plpSQL language in
Andrus wrote:
Currently all my database objects are owned by superuser postgres .
I need to change owner to a nonprivileged role for all objects in a
database.
I'm using Postgres 8.1 server and client in Windows XP, only plpSQL language
installed in server.
Search the mailing list archives
Currently all my database objects are owned by superuser postgres .
I need to change owner to a nonprivileged role for all objects in a
database.
I'm using Postgres 8.1 server and client in Windows XP, only plpSQL language
installed in server.
I'm thinking about the following possibilities:
1
