EPUB | CHM | PDF

TPSQLDump.Properties.Role

Top Previous Next

Specifies role name to use for dump.

Syntax:

property Role: string

Description:

Specifies a role name to be used to create the dump. This property causes TPSQLDump to issue a SET ROLE rolename command after connecting to the database. It is useful when the authenticated user lacks privileges needed by TPSQLDump, but can switch to a role with the required rights. Some installations have a policy against logging in directly as a superuser, and use of this option allows dumps to be made without violating the policy.