EPUB | CHM | PDF

TPSQLRestore.Properties.Role

Top Previous Next

Specifies role name to use for restore.

Syntax:

property Role: string

Description:

Specifies a role name to be used to perform the restore. This option causes TPSQLRestore to issue a SET ROLE rolename command after connecting to the database. It is useful when the authenticated user lacks privileges needed by TPSQLRestore, 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 restores to be performed without violating the policy.