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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
