AwsRdsPostgresqlUserGrantArgs

interface AwsRdsPostgresqlUserGrantArgs {
columns?: string[];
database?: string;
objects?: string[];
objectType: 'function' | 'database' | 'schema' | 'table' | 'sequence' | 'procedure' | 'routine' | 'foreign_data_wrapper' | 'foreign_server' | 'column';
privileges: string[];
schema?: string;
}

PostgreSQL privilege grant assigned to a managed login role.

Example

CODE

import type { AwsRdsPostgresqlUserGrantArgs } from '@jobcloud/aws-rds';

const ordersRead: AwsRdsPostgresqlUserGrantArgs = {
  objectType: 'table',
  schema: 'public',
  privileges: ['SELECT'],
};

Properties

`columns: string[]`

Explicit columns for a column grant.

`database: string`

Database receiving the grant. Defaults to the provider connection database.

`objects: string[]`

Explicit objects; omit to cover all objects of the selected type.

`objectType: 'function' | 'database' | 'schema' | 'table' | 'sequence' | 'procedure' | 'routine' | 'foreign_data_wrapper' | 'foreign_server' | 'column'`

PostgreSQL object type receiving privileges.

`privileges: string[]`

Privileges granted to the role.

`schema: string`

Database schema, required by PostgreSQL for non-database objects.