Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] phantom rights - Mailing list pgsql-admin

From Thomas Poty
Subject [ADMIN] phantom rights
Date
Msg-id CAN_ctniVaZUTme84LwT6AW9BBK=vgaBPQzjzW+TeKU4rnu3fDg@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] phantom rights  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Anthony Sotolongo
Date:
Subject: Re: [PERFORM] [ADMIN] 2 server with same configuration but hugedifference in performance
Next
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] [PERFORM] 2 server with same configuration but huge difference in performance