Top Previous Next

Specifies role name to use for restore.


property Role: string


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.