Re: Is read-only user of Phoeix table possible?

2018-08-27 Thread Thomas D'Silva
I misspoke on my earlier email, the behavior I described is valid from Phoenix 4.14+. You are probably running in to PHOENIX-2717, which was fixed in 4.11 On Mon, Aug 27, 2018 at 9:06 AM, Josh Elser wrote: > Note, that the functionality that Thomas describes is how we intend > Phoenix to

Re: Is read-only user of Phoeix table possible?

2018-08-27 Thread Josh Elser
Note, that the functionality that Thomas describes is how we intend Phoenix to work, and may not be how the 4.9 release of Phoenix works (due to changes that have been made). On 8/23/18 12:42 PM, Thomas D'Silva wrote: On a new cluster, the first time a client connects is when the SYSTEM

Re: Is read-only user of Phoeix table possible?

2018-08-23 Thread Thomas D'Silva
On a new cluster, the first time a client connects is when the SYSTEM tables are created. You need to connect with a user that has RWX on the SYSTEM schema the very first time. After that user1 should be able to connect. Also from the doc: Every user requires 'RX' permissions on all Phoenix SYSTEM