phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pedro Boado <pedro.bo...@gmail.com>
Subject Read only user permissions to Phoenix table - Phoenix 4.5
Date Thu, 16 Feb 2017 10:03:31 GMT
Hi all,

I have a quick question. We are still running on Phoenix 4.5 (I know, it's
not my fault) and we're trying to setup a read only user on a phoenix
table. The minimum set of permissions to get access through sqlline is

grant 'readonlyuser' , 'RXC', 'SYSTEM.CATALOG'
grant 'readonlyuser' , 'RXC', 'SYSTEM.SEQUENCE'
grant 'readonlyuser' , 'RXC', 'SYSTEM.STATS'
grant 'readonlyuser' , 'RXC', 'SYSTEM.FUNCTION'
grant 'readonlyuser' , 'RX', 'READONLY.TABLENAME'

I was wondering whether there is a way for avoiding the need of the CREATE
permission on catalog tables.

Cheers,
Pedro.

Mime
View raw message