Skip to main content

  • ​
    grantPermission

    public GrantPermissionResponse grantPermission(GrantPermissionRequest request) throws GPUdbException
    Grant user or role the specified permission on the specified object.
    Parameters:
    request - Request object containing the parameters for the operation.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.

  • ​
    grantPermission

    public GrantPermissionResponse grantPermission(String principal, String object, String objectType, String permission, Map<String,String> options) throws GPUdbException
    Grant user or role the specified permission on the specified object.
    Parameters:
    principal - Name of the user or role for which the permission is being granted. Must be an existing user or role. The default value is ”.
    object - Name of object permission is being granted to. It is recommended to use a fully-qualified name when possible.
    objectType - The type of object being granted to. Supported values:
    permission - Permission being granted. Supported values:
    • ADMIN: Full read/write and administrative access on the object.
    • CONNECT: Connect access on the given data source or data sink.
    • CREATE: Ability to create new objects of this type.
    • DELETE: Delete rows from tables.
    • EXECUTE: Ability to Execute the Procedure object.
    • INSERT: Insert access to tables.
    • MONITOR: Monitor logs and statistics.
    • READ: Ability to read, list and use the object.
    • SEND_ALERT: Ability to send system alerts.
    • UPDATE: Update access to the table.
    • USER_ADMIN: Access to administer users and roles that do not have system_admin permission.
    • WRITE: Access to write, change and delete objects.
    options - Optional parameters.
    • COLUMNS: Apply table security to these columns, comma-separated. The default value is ”.
    • FILTER_EXPRESSION: Filter expression to apply to this grant. Only rows that match the filter will be affected. The default value is ”.
    • WITH_GRANT_OPTION: Allow the recipient to grant the same permission (or subset) to others. Supported values:The default value is FALSE.
    The default value is an empty Map.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.