Skip to main content
Grants a system-level permission to a user or role.

Input Parameter Description

string
Name of the user or role to which the permission will be granted. Must be an existing user or role.
string
Permission to grant to the user or role.
  • system_admin: Full access to all data and system functions.
  • system_user_admin: Access to administer users and roles that do not have system_admin permission.
  • system_write: Read and write access to all tables.
  • system_read: Read-only access to all tables.
  • system_send_alert: Send system alerts.
map of string to strings
Optional parameters.The default value is an empty map ( {} ).

Output Parameter Description

The Kinetica server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:
String
‘OK’ or ‘ERROR’
String
Empty if success or an error message
String
‘grant_permission_system_response’ or ‘none’ in case of an error
String
Empty string
JSON or String
This embedded JSON represents the result of the /grant/permission/system endpoint:Empty string in case of an error.