From: | "Fran (dot)(dot)(dot)" <Bryan691(at)hotmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Subject: | Re: Role and grants |
Date: | 2016-11-09 22:46:08 |
Message-ID: | AM4PR03MB174858B4373951A8CF4716F597B90@AM4PR03MB1748.eurprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for your reply.
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".
With this other command neither I get more information:
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
postgres | Superuser, Create role, Create DB, Replication | {}
test1 | | {}
Regards.
________________________________
De: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Enviado: miércoles, 9 de noviembre de 2016 21:02
Para: Fran ...; pgsql-general(at)postgresql(dot)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 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?
>
>
> Transcript:
>
>
> postgres=# create database test;
> CREATE DATABASE
> postgres=# create user test with password 'test';
> CREATE ROLE
> postgres=# grant all privileges on database test to test;
> GRANT
My guess is the above is not doing what you think it is. See further
comments below for seeing what 'grant all privileges on database' gets you.
> postgres=# \l
> List of databases
> Name | Owner | Encoding | Collate | Ctype | Access
> privileges
> -----------+----------+----------+-------------+-------------+-----------------------
> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> =c/postgres +
> | | | | |
> postgres=CTc/postgres
> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> =c/postgres +
> | | | | |
> postgres=CTc/postgres
> test | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> =Tc/postgres +
> | | | | |
> postgres=CTc/postgres+
> | | | | |
> test=CTc/postgres
> test1 | test1 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/test1
> +
> | | | | |
> test1=CTc/test1
> (5 rows)
>
> With "\l" command It's no clear.
To understand the abbreviations see here:
https://www.postgresql.org/docs/9.5/static/sql-grant.html
PostgreSQL: Documentation: 9.5: GRANT<https://www.postgresql.org/docs/9.5/static/sql-grant.html>
www.postgresql.org
GRANT on Database Objects. This variant of the GRANT command gives specific privileges on a database object to one or more roles. These privileges are added to those ...
Look for:
"The entries shown by \dp are interpreted thus:"
>
>
> Finally, I don't find some command like "show grants for..." in MySQL.
>
>
> Regards.
>
> Bryan
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-11-09 22:52:36 | Re: Role and grants |
Previous Message | Adrian Klaver | 2016-11-09 20:02:41 | Re: Role and grants |