Re: Role and grants

On 11/09/2016 02:46 PM, Fran ... wrote:
>
> 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".

It is explained in the documentation at the link
(https://www.postgresql.org/docs/9.5/static/sql-grant.html) Look under
the section:

"The possible privileges are:"

Also see John's post.

>
> 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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com