|
None of the roles have permissions on the postgres database. At this point they don't have any permissions on any databases.
I have noted that "GRANT ALL ON SCHEMA public TO public" is granted on postgres.schemas.public. I am looking at this in pgadmin so excuse my nomenclature.
Is this what is allowing write access to the database?
From: Melvin Davidson <melvin6925@xxxxxxxxx>
Sent: Tuesday, June 2, 2015 12:55 PM To: Steve Pribyl Cc: Joshua D. Drake; pgsql-general@xxxxxxxxxxxxxx Subject: Re: postgres db permissions Your problem is probably the "INHERIT" and
options. If any of the dbA's have the permission to CREATE tables (and I suspect they do), so will bob.GRANT dbA TO bob; GRANT dbA_ro TO bob; GRANT dbB TO bob; GRANT dbB_ro TO bob; On Tue, Jun 2, 2015 at 1:50 PM, Steve Pribyl
<Steve.Pribyl@xxxxxxxxxxxxxxxx> wrote:
Josh, -- Melvin Davidson
I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. Steve Pribyl | Senior Systems Engineer Akuna Capital LLC 36 S Wabash, Suite 310 Chicago IL 60603 USA | www.akunacapital.com p: +1 312 994 4646 | m: 847-343-2349 | f: +1 312 750 1667 | Steve.Pribyl@xxxxxxxxxxxxxxxx Please consider the environment, before printing this email. This electronic message contains information from Akuna Capital LLC that may be confidential, legally privileged or otherwise protected from disclosure. This information is intended for the use of the addressee only and is not offered as investment advice to be relied upon for personal or professional use. Additionally, all electronic messages are recorded and stored in compliance pursuant to applicable SEC rules. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, printing or any other use of, or any action in reliance on, the contents of this electronic message is strictly prohibited. If you have received this communication in error, please notify us by telephone at (312)994-4640 and destroy the original message. |
