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