GRANT SYSTEM Permission - Kinetica Docs

System permissions can be granted directly to users or roles.

System Administration

GRANT System Administrative Permission Syntax

GRANT SYSTEM ADMIN TO <user name | role name>

Permission	Description
`SYSTEM ADMIN`	System administrator permission

GRANT System Management Permission Syntax

GRANT SYSTEM < CREATE | MONITOR | READ | WRITE > TO <user name | role name> [WITH GRANT OPTION]

Permission	Description
`SYSTEM CREATE`	System create permission
`SYSTEM MONITOR`	System monitor permission
`SYSTEM READ`	System read permission
`SYSTEM WRITE`	System write permission
`WITH GRANT OPTION`	Grant this permission with a grant option to grant it to others.

GRANT User Administrative Permission Syntax

GRANT USER ADMIN TO <user name | role name>

Permission	Description
`USER ADMIN`	User administrator permission

To grant system administrator permission to jsmith:

GRANT SYSTEM ADMIN Example

GRANT SYSTEM ADMIN TO jsmith

To grant read access to all tables to the auditor role:

GRANT SYSTEM READ Example

GRANT SYSTEM READ TO auditor

To grant user administrator permission to jsmith:

GRANT USER ADMIN Example

GRANT USER ADMIN TO jsmith