phantom rights

From: Thomas Poty <thomas(dot)poty(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: phantom rights
Date: 2017-08-01 14:53:53
Message-ID: CAN_ctniVaZUTme84LwT6AW9BBK=vgaBPQzjzW+TeKU4rnu3fDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello world,

I wonder if the problem of "phantom rights" exists in Postgresql 9.5 as it
exists in MySQL.

What happens with privileges if :
- I create a table t1
- I grant to user u1 some privileges for the table t1
- I drop table t1;
- and I recreate de same table t1

Are these privileges still existing or completely revoked/deleted with the
drop table statement?

Thanks a lot,

Regards,

Thomas

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2017-08-01 15:35:20 Re: [PERFORM] 2 server with same configuration but huge difference in performance
Previous Message Anthony Sotolongo 2017-08-01 14:21:02 Re: [PERFORM] 2 server with same configuration but huge difference in performance