table cf column list
Lists column-level attributes including any dynamic data masking properties set for JSON table columns.
Syntax
- CLI
-
maprcli table cf column list -path <table-path> -cfname <column family name> [ -name <column-name>
- REST
-
http[s]://<host>:<port>/rest/table/cf/column/list?<parameters>
Parameters
Parameter |
Description |
---|---|
path |
The path to the HPE Ezmeral Data Fabric Database table.
|
cfname | The name of the column family of the JSON table field. |
name | The JSON column family feld to list attributes. If omitted, all columns for the specified column family that have associated column-level attributes are returned. |
Example
In the following example, only user mapr
can read column
Creditcard
from the default CF of table /table1
unmasked. User user1
can read the Creditcard
column, but
it will be masked:
- CLI
-
maprcli table cf colperm set -path /table1--cfname default \ -name Creditcard –readperm "u:user1|u:mapr" -unmaskedreadperm "u:mapr" \ -writeperm "u:mapr" maprcli table cf column securitypolicy set -path /table1 -cfname default \ -name Creditcard -securitypolicy pci maprcli table cf column datamask set –path /table1 -cfname default \ -name Creditcard -datamask mrddm_last4 maprcli table cf column list -path /table1 -cfname default -json { "timestamp":1612303576139, "timeofday":"2021-02-02 02:06:16.139 GMT-0800 PM", "status":"OK", "total":1, "data":[ { "name":"Creditcard", "aces": { "readperm":"u:user1|u:mapr", "unmaskedreadperm":"u:mapr", "writeperm":"u:mapr" }, "securitypolicy":"pci", "datamask":"mrddm_last4" } ]