Displaying Column Family Permissions

Use either a maprcli command or MCS to find out the users, groups, or roles that have permissions on a column family or column.

maprcli command

To display the permissions on a column family, run this command
maprcli table cf colperm get -path <path> -cfname <name of column family> -json
To display the permissions on a column, add the -name parameter:
maprcli table cf colperm get -path <path> -cfname <name of column family> -name 
<name of column> -json

The format of the value of the -path parameter depends on whether you are creating a table on a local cluster or a remote cluster:

  • For a path on the local cluster, start the path at the volume mount point. For example, for a table named test under a volume with a mount point at /volume1, specify the following path: /volume1/test
  • For a path on a remote cluster, you must also specify the cluster name in the path. For example, for a table named customer under volume1 in the sanfrancisco cluster, specify the following path:/mapr/sanfrancisco/volume1/customer

The json parameter displays the output as a JSON document.

MCS

  1. Open the table in which the column family or column is located.
  2. Click the Column Families tab.

    Figure: Where to find the Column Families tab

  3. Click the Edit Column Family button.

The Edit Column Family window opens. There is a section for permissions on the column family and another section for permissions on the columns.

Figure: The two sections for permissions in the Edit Column Family window

To edit any permissions for a column, select that column. The controls that display its permissions then appear.

Figure: The permission controls for Column_A, the selected column