Manage Privileges #

Paimon provides a privilege system on catalogs. Privileges determine which users can perform which operations on which objects, so that you can manage table access in a fine-grained manner.

Currently, Paimon adopts the identity-based access control (IBAC) privilege model. That is, privileges are directly assigned to users.

This privilege system only prevents unwanted users from accessing tables through catalogs. It does not block access through temporary table (by specifying table path on filesystem), nor does it prevent user from directly modifying data files on filesystem. If you need more serious protection, use a filesystem with access management instead.

Basic Concepts #

We now introduce the basic concepts of the privilege system.

Object #

An object is an entity to which access can be granted. Unless allowed by a grant, access is denied.

Currently, the privilege system in Paimon has three types of objects: CATALOG, DATABASE and TABLE. Objects have a logical hierarchy, which is related to the concept they represent. For example:

• If a user is granted a privilege on the catalog, he will also have this privilege on all databases and all tables in the catalog.
• If a user is granted a privilege on the database, he will also have this privilege on all tables in that database.
• If a user is revoked a privilege from the catalog, he will also lose this privilege on all databases and all tables in the catalog.
• If a user is revoked a privilege from the database, he will also lose this privilege on all tables in that database.

Privilege #

A privilege is a defined level of access to an object. Multiple privileges can be used to control the granularity of access granted on an object. Privileges are object-specific. Different objects may have different privileges.

Currently, we support the following privileges.

User #

The entity to which privileges can be granted. Users are authenticated by their password.

When the privilege system is enabled, two special users will be created automatically.

• The root user, which is identified by the provided root password when enabling the privilege system. This user always has all privileges in the catalog.
• The anonymous user. This is the default user if no username and password is provided when creating the catalog.

Enable Privileges #

Paimon currently only supports file-based privilege system. Only catalogs with 'metastore' = 'filesystem' (the default value) or 'metastore' = 'hive' support such privilege system.

To enable the privilege system on a filesystem / Hive catalog, do the following steps.

-- use the catalog where you want to enable the privilege system
USE CATALOG `my-catalog`;
    
-- initialize privilege system by providing a root password
-- change 'root-password' to the password you want
CALL sys.init_file_based_privilege('root-password');

After the privilege system is enabled, please re-create the catalog and authenticate as root to create other users and grant them privileges.

Privilege system does not affect existing catalogs. That is, these catalogs can still access and modify the tables freely. Please drop and re-create all catalogs with the desired warehouse path if you want to use the privilege system in these catalogs.

Accessing Privileged Catalogs #

To access a privileged catalog and to be authenticated as a user, you need to define user and password catalog options when creating the catalog. For example, the following SQL creates a catalog while trying to be authenticated as root, whose password is mypassword.

CREATE CATALOG `my-catalog` WITH (
    'type' = 'paimon',
    -- ...
    'user' = 'root',
    'password' = 'mypassword'
);

Creating Users #

You must be authenticated as a user with ADMIN privilege (for example, root) to perform this operation.

Do the following steps to create a user in the privilege system.

-- use the catalog where you want to create a user
-- you must be authenticated as a user with ADMIN privilege in this catalog
USE CATALOG `my-catalog`;

-- create a user authenticated by the specified password
-- change 'user' and 'password' to the username and password you want
CALL sys.create_privileged_user('user', 'password');

Dropping Users #

You must be authenticated as a user with ADMIN privilege (for example, root) to perform this operation.

Do the following steps to drop a user in the privilege system.

-- use the catalog where you want to drop a user
-- you must be authenticated as a user with ADMIN privilege in this catalog
USE CATALOG `my-catalog`;

-- change 'user' to the username you want to drop
CALL sys.drop_privileged_user('user');

Granting Privileges to Users #

You must be authenticated as a user with ADMIN privilege (for example, root) to perform this operation.

Do the following steps to grant a user with privilege in the privilege system.

-- use the catalog where you want to drop a user
-- you must be authenticated as a user with ADMIN privilege in this catalog
USE CATALOG `my-catalog`;

-- you can change 'user' to the username you want, and 'SELECT' to other privilege you want
-- grant 'user' with privilege 'SELECT' on the whole catalog
CALL sys.grant_privilege_to_user('user', 'SELECT');
-- grant 'user' with privilege 'SELECT' on database my_db
CALL sys.grant_privilege_to_user('user', 'SELECT', 'my_db');
-- grant 'user' with privilege 'SELECT' on table my_db.my_tbl
CALL sys.grant_privilege_to_user('user', 'SELECT', 'my_db', 'my_tbl');

Revoking Privileges to Users #

You must be authenticated as a user with ADMIN privilege (for example, root) to perform this operation.

Do the following steps to revoke a privilege from user in the privilege system.

-- use the catalog where you want to drop a user
-- you must be authenticated as a user with ADMIN privilege in this catalog
USE CATALOG `my-catalog`;

-- you can change 'user' to the username you want, and 'SELECT' to other privilege you want
-- revoke 'user' with privilege 'SELECT' on the whole catalog
CALL sys.revoke_privilege_from_user('user', 'SELECT');
-- revoke 'user' with privilege 'SELECT' on database my_db
CALL sys.revoke_privilege_from_user('user', 'SELECT', 'my_db');
-- revoke 'user' with privilege 'SELECT' on table my_db.my_tbl
CALL sys.revoke_privilege_from_user('user', 'SELECT', 'my_db', 'my_tbl');