Home > mailing lists

Thread: How to create users for a login Role?

How to create users for a login Role?

From

KhunSanAung

Date:

12 October 2015, 07:35:09

Dear All,

I know how to create a login role for a postgres database.

I used pgAdmin III to create login role and database.

or via psql command;

postgres=# CREATE ROLE dbuser PASSWORD 'secret' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

I'd like to know how to create users/members for each login role.

How can I do it?

I'd like to allow multiple users to access to a database.

I used postgres installed Ubuntu Server and access by pgAdmin III and SSH from Window OS.

Many thanks & best regards

Have a nice day!
--

Mr. Khun San Aung

НА: How to create users for a login Role?

From

Evgeniy Losev

Date:

12 October 2015, 10:18:37

Hi,
Please, clarify your question.
Do you want to create login role with password and grant it to several users?

Evgeniy Losev

От: KhunSanAung
Отправлено: 12.10.2015 7:35
Кому: pgsql-admin
Тема: [ADMIN] How to create users for a login Role?

Dear All,

I know how to create a login role for a postgres database.

I used pgAdmin III to create login role and database.

or via psql command;

postgres=# CREATE ROLE dbuser PASSWORD 'secret' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

I'd like to know how to create users/members for each login role.

How can I do it?

I'd like to allow multiple users to access to a database.

I used postgres installed Ubuntu Server and access by pgAdmin III and SSH from Window OS.

Many thanks & best regards

Have a nice day!
--

Mr. Khun San Aung

Re: How to create users for a login Role?

From

KhunSanAung

Date:

12 October 2015, 10:42:47

Hi All,

Yes.

I have a database, myDatabase1 with owner (I think the same as login role) db1Owner.

At the moment, I can login to the database with above user only. No other dbUser can access to it.

I have several tables inside the database.

The database is accessible only with the above login. It is not accessible to other role/user.

What I like to have is create several users for a database.

e.g.

I like to allow dbUsers1 , dbUsers2, dbUser3,... to be able to access to the same database (db1Database).

Currently if I assign the dbUsers1 as the owner of the database, the 'db1Owner' cannot not access to the 'myDatabase1' database.

How can I allow multi users to allow to access and edit the database?

How can I create multiple database users to allow to access to the same database?

I'm just a beginner to postgresDB.

Many thanks & best regards

On Mon, Oct 12, 2015 at 1:48 PM, Evgeniy Losev <e.losev@i-free.com> wrote:

Hi,
Please, clarify your question.
Do you want to create login role with password and grant it to several users?

Evgeniy Losev

От: KhunSanAung
Отправлено: 12.10.2015 7:35
Кому: pgsql-admin
Тема: [ADMIN] How to create users for a login Role?

Dear All,

I know how to create a login role for a postgres database.
I used pgAdmin III to create login role and database.
or via psql command;
postgres=# CREATE ROLE dbuser PASSWORD 'secret' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

I'd like to know how to create users/members for each login role.
How can I do it?
I'd like to allow multiple users to access to a database.

I used postgres installed Ubuntu Server and access by pgAdmin III and SSH from Window OS.

Many thanks & best regards

--
Have a nice day!
--
Mr. Khun San Aung

Have a nice day!
--

Mr. Khun San Aung

Re: How to create users for a login Role?

From

Evgeniy Losev

Date:

12 October 2015, 10:50:03

Hi.

You can create a separate role for database usage and referenig docs at http://www.postgresql.org/docs/9.3/static/sql-grant.html grant particular capabilities to it.

and then grant the role to your users.

Evgeniy Losev

Senior System Administrator
i-Free Business Solutions

От: KhunSanAung <khunsanaung.gis@gmail.com>
Отправлено: 12 октября 2015 г. 10:42
Кому: Evgeniy Losev
Копия: pgsql-admin
Тема: Re: [ADMIN] How to create users for a login Role?

Hi All,

Yes.

I have a database, myDatabase1 with owner (I think the same as login role) db1Owner.

At the moment, I can login to the database with above user only. No other dbUser can access to it.

I have several tables inside the database.

The database is accessible only with the above login. It is not accessible to other role/user.

What I like to have is create several users for a database.

e.g.

I like to allow dbUsers1 , dbUsers2, dbUser3,... to be able to access to the same database (db1Database).

Currently if I assign the dbUsers1 as the owner of the database, the 'db1Owner' cannot not access to the 'myDatabase1' database.

How can I allow multi users to allow to access and edit the database?

How can I create multiple database users to allow to access to the same database?

I'm just a beginner to postgresDB.

Many thanks & best regards

On Mon, Oct 12, 2015 at 1:48 PM, Evgeniy Losev <e.losev@i-free.com> wrote:

Hi,
Please, clarify your question.
Do you want to create login role with password and grant it to several users?

Evgeniy Losev
От: KhunSanAung
Отправлено: 12.10.2015 7:35
Кому: pgsql-admin
Тема: [ADMIN] How to create users for a login Role?

Dear All,

I know how to create a login role for a postgres database.
I used pgAdmin III to create login role and database.
or via psql command;
postgres=# CREATE ROLE dbuser PASSWORD 'secret' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

I'd like to know how to create users/members for each login role.
How can I do it?
I'd like to allow multiple users to access to a database.

I used postgres installed Ubuntu Server and access by pgAdmin III and SSH from Window OS.

Many thanks & best regards

--
Have a nice day!
--
Mr. Khun San Aung

Have a nice day!
--

Mr. Khun San Aung

Re: How to create users for a login Role?

From

Albe Laurenz

Date:

12 October 2015, 11:34:17

KhunSanAung wrote:
> I know how to create a login role for a postgres database.
> I used pgAdmin III to create login role and database.
> or via psql command;
> postgres=# CREATE ROLE dbuser PASSWORD 'secret' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
> 
> 
> I'd like to know how to create users/members for each login role.
> How can I do it?
> I'd like to allow multiple users to access to a database.
> 
> I used postgres installed Ubuntu Server and access by pgAdmin III and SSH from Window OS.

I guess the problem here is a confusion over "user", "group" and "role".

In PostgreSQL, there is no difference between user and role.

A "group" is a role (usually with NOLOGIN), and a "user" is a role with LOGIN.
You add a "user" to a "group" by granting the "group" to the "user:

GRANT usergroup TO user1;

If you want to give a bunch of users a certain set of privileges,
grant the privileges to a NOLOGIN role and grant that role to the users.

Yours,
Laurenz Albe