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 tables in order to work correctly. Users also require 'RWX' permissions on SYSTEM.SEQUENCE table for using SEQUENCES.
On Wed, Aug 22, 2018 at 10:38 PM, Sumanta Gh <[email protected]> wrote: > Hi, > > I have a Kerberos enabled Hbase 1.2 cluster with Phoenix 4.9. > In hbase shell, I have granted an hbase user with permission R. > > hbase shell > grant 'user1', 'R' > > Now while connecting through SqlLine, I am getting the below error - > > Insufficient permissions ([email protected], > scope=default:SYSTEM.CATALOG, params=[table=default:SYSTEM. > CATALOG],action=CREATE > > Is the Phoenix client trying to CREATE a table everytime? For this issue, > I am not able to create an absolute read-only user of Hbase. > NB : All Phoenix tables are already created > > Kindly help to resolve this issue. > > > Regards > Sumanta > > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > >
