https://community.cloudera.com/t5/Support-Questions/Phoenix-security-and-initial-system-table-creation/m-p/155364#M117803 <P>1. No, SYSTEM tables are created for all Phoenix users.</P><P>2. When a user makes the first connection to Phoenix (instantiates the JDBC driver) it will check and try to create the SYSTEM tables if they don't already exist. For all but the first connection, this will be a no-op. If you have permissions put in place, you will want to launch sqlline (or some application using Phoenix) which has the permission to create these SYSTEM tables. Then, before having unprivileged users access phoenix, make sure they have read permission on the system tables.</P><P>3. You can create an HBase Namespace, grant privileges on that namespace to a user, and then instruct the user to create phoenix tables like "MY_NAMESPACE.MY_TABLE".</P> Sat, 29 Oct 2016 00:09:12 GMT elserj 2016-10-29T00:09:12Z