Access Control

Plato lets you secure your data with a simple locking feature that marks data as read-only. You can lock data at the database, table, and column levels.

Databases

After you connect a new database, it is locked by default.

To unlock a database:

1. Click on the database in the nav bar.
2. Click “Unlock database”.

Tables

If a database is locked, all of its tables are also locked. To unlock a table, you must first unlock its database.

Once you unlock the database, you can lock specific tables. To lock a table:

1. Click on the table in the left-hand nav bar.
2. Click on the vertical ellipsis on the right-hand side of the tables control bar.
3. Click “Lock table”.

A note on joins: if you expand a linked record column, the columns of its target table will be editable if and only if the base table is unlocked. In other words, the lock state of the joined table is determined by the lock state of the base table.

Columns

If a table is locked, all of its columns are also locked. To unlock a column, you must first unlock its table.

Once a table is unlocked, you can lock specific columns. To lock a column:

1. Right click on the column header.
2. Click “Lock column”.