Re: Role and grants

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 Create and Usage permissions.

a TABLE has select, insert, update, delete, truncate, references,
trigger permissions.

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

those are role(user) attributes, which is something quite different than
object permissions.

--
john r pierce, recycling bits in santa cruz