Re: [GENERAL] Role and grants

2016-11-09 Thread Adrian Klaver
| {} Regards. *De:* Adrian Klaver *Enviado:* miƩrcoles, 9 de noviembre de 2016 21:02 *Para:* Fran ...; pgsql-general@postgresql.org *Asunto:* Re: [GENERAL] Role and grants On 11/09/2016 11:05 AM, Fran ... wrote: Hi, I am a new user with PostgreSQL, I came from MySQ

Re: [GENERAL] Role and grants

2016-11-09 Thread John R Pierce
On 11/9/2016 2:46 PM, Fran ... wrote: I had seen that link from documentation but I do not understand why it prints just "connect,temporary and create": CTc/test1 I think it should be print "arwdDxt". Connect, Temporary and Create are the only permissions a DATABASE has. a SCHEMA has Cre

Re: [GENERAL] Role and grants

2016-11-09 Thread Fran ...
| {} Regards. De: Adrian Klaver Enviado: miƩrcoles, 9 de noviembre de 2016 21:02 Para: Fran ...; pgsql-general@postgresql.org Asunto: Re: [GENERAL] Role and grants On 11/09/2016 11:05 AM, Fran ... wrote: > Hi, > > > I am a new user with Postgr

Re: [GENERAL] Role and grants

2016-11-09 Thread Adrian Klaver
On 11/09/2016 11:05 AM, Fran ... wrote: Hi, I am a new user with PostgreSQL, I came from MySQL and I am experiencing some issues with roles and privileges. I have created a DB,user and grant privilege on this DB to this user. How could I check what is the privileges/permissions for this user?

Re: [GENERAL] Role and grants

2016-11-09 Thread Melvin Davidson
On Wed, Nov 9, 2016 at 2:05 PM, Fran ... wrote: > Hi, > > > I am a new user with PostgreSQL, I came from MySQL and I am experiencing > some issues with roles and privileges. > > > I have created a DB,user and grant privilege on this DB to this user. How > could I check what is the privileges/perm