Page 1 of 1
Register a new server and a new role in PostgreSQL
Posted: Mon 10 Nov 2014 15:51
by piopio1
Hello,
Is there a way to register a new server and a new role with DAC components ?
Many thanks
Pio Pio
Re: Register a new server and a new role in PostgreSQL
Posted: Tue 11 Nov 2014 07:24
by AlexP
hello,
Please clarify: what do you mean by "register a new server and a new role"?
Re: Register a new server and a new role in PostgreSQL
Posted: Tue 11 Nov 2014 10:51
by piopio1
AlexP wrote:hello,
Please clarify: what do you mean by "register a new server and a new role"?
Hi AlexP
For create role I mean create user
http://www.postgresql.org/docs/9.2/stat ... euser.html
Just disregard the create server.
Thanks
Pio Pio
Re: Register a new server and a new role in PostgreSQL
Posted: Tue 11 Nov 2014 11:45
by AlexP
You can create a user/role (or any database object) by executing a correspondent script. You can execute the script in the ExecSQL method, for example:
Code: Select all
PgConnection1.ExecSQL('createuser joe');
Re: Register a new server and a new role in PostgreSQL
Posted: Tue 11 Nov 2014 14:45
by piopio1
AlexP wrote:You can create a user/role (or any database object) by executing a correspondent script. You can execute the script in the ExecSQL method, for example:
Code: Select all
PgConnection1.ExecSQL('createuser joe');
Thank you very much for your explanation, AlexP.
Pio Pio
Re: Register a new server and a new role in PostgreSQL
Posted: Wed 12 Nov 2014 05:21
by AlexP
You are welcome. Feel free to contact us if you have any further questions.