Command Reference

Home / Guide / Command Reference

Access Control

    You can selectively block accesses from specific IP addresses or allow them. It can be done by setting access control list and access control mode. Access control mode is access control setting for users who are not set on the access control list. If there is no access privilege and the access control mode is set to DENY, or in contrary the access control mode is set to ALLOW but the IP is registered to the access control list, then encryption and decryption are unavailable for that IP to the column registered. If the access control mode is DENY, then you should give access privilege for all columns in the certain table to give permission to look at the table. Remember that access control setting is only appliable to the tables D’Amo for MySQL manages.

    • SET PRIV ACCESS <ip>”<user>”<owner>”<table>”<column>”<priv>
    • <ip>: IP address to give privilege.
    • <user>: User name to give privilege.
    • <owner>: Owner name which owns the table with the encryption column.
    • <table>: Table name which has the encryption column.
    • <column>: The name of the encryption column.
    • <priv>: Access privilege. (0: deny, 1: allow)

    #fancy-title-5c0f5aeb20c5e a{ color: #5b5b5b; }

    • DELETE PRIV ACCESS <ip>”<user>”<owner>”<table>”<column>
    • <ip>: IP address which was given access privilege.
    • <user>: User name which was given access privilege.
    • <owner>: Owner name which owns the table with the encryption column.
    • <table>: Table name which has the encryption column.
    • <column>: The name of the encryption column.

    #fancy-title-5c0f5aeb20f51 a{ color: #5b5b5b; }
    You can set the access control mode by following commands.

    • SET ENV ACCESS ALLOW
    • Explanation: Sets Access Control to Allow mode. In Allow mode, system only blocks accesses which is in the access deny list.

    #fancy-title-5c0f5aeb2148d a{ color: #5b5b5b; }

    • SET ENV ACCESS DENY
    • Explanation: Sets Access COntrol to Deny mode. In Deny mode, system only accepts accesses which is in the access allow list and blocks every others.

    #fancy-title-5c0f5aeb216d8 a{ color: #5b5b5b; }
    #icon-font-5c0f5aeb219dc i { background-color:; color:#000000; border-color:; } #icon-font-5c0f5aeb219dc i:hover { background-color:; color:rgba(0,0,0,0.51); border-color:; }

    #fancy-title-5c0f5aeb228fc a{ color: #274e75; }