<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: Phoenix security and initial system table creation in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Phoenix-security-and-initial-system-table-creation/m-p/155367#M117806</link>
    <description>&lt;P&gt;&lt;BR /&gt;&lt;A rel="user" href="https://community.cloudera.com/users/223/jelser.html" nodeid="223"&gt;@Josh Elser&lt;/A&gt; I have followed the above steps,but, have problem when I revoke the write and create permissions for the user post first login. &lt;/P&gt;&lt;P&gt;Env: HDP 2.6 &lt;/P&gt;&lt;P&gt;Enabled phoenix.schema.isNamespaceMappingEnabled&lt;/P&gt;&lt;P&gt;Kerberos and Ranger Hbase plugin enabled.&lt;/P&gt;&lt;P&gt;Post Enabling the property:&lt;/P&gt;&lt;P&gt;1) Added the user to default policy which enables all permissions.&lt;/P&gt;&lt;P&gt;2) login using phoenix-sqlline zookeeper-quorum:2181:/hbase-secure got connected without any issue. &lt;/P&gt;&lt;P&gt;3) logged out and removed the WCA from Ranger policy. &lt;/P&gt;&lt;P&gt;Below is the error.&lt;/P&gt;&lt;P&gt;Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.security.AccessDeniedException): org.apache.hadoop.hbase.security.AccessDeniedException: Insufficient permissions for user ‘user@REALM',action: put, tableName:SYSTEM:CATALOG, family:0, column: _0
        at org.apache.ranger.authorization.hbase.RangerAuthorizationCoprocessor.requirePermission(RangerAuthorizationCoprocessor.java:551)&lt;/P&gt;</description>
    <pubDate>Fri, 01 Sep 2017 18:12:21 GMT</pubDate>
    <dc:creator>sriramdboss</dc:creator>
    <dc:date>2017-09-01T18:12:21Z</dc:date>
  </channel>
</rss>

