On 5/30/2017 2:06 PM, chiru r wrote:
Is there any reason, why it is showing roles name as owner of table instead of user?
'user' is a synonym for 'role' with login permission.
CREATE USER fred;
is exactly the same as...
CREATE ROLE fred WITH LOGIN;
when you SET ROLE rolename; its virtually the same as logging in as rolename
Why it is not allowed to GRANT SUPERUSER/CREATEDB etc roles Directly to user (using GRANT ,not ALTER USER) ?
GRANT is used to grant object related permissions or to grant role membership, its not a 'role' nor do roles inherit special attributes like SUPERUSER, CREATEDB.
--
john r pierce, recycling bits in santa cruz