Re: Access Management question

[John R Pierce <pierce@xxxxxxxxxxxx>]

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