If when trying to restore a HP ALM project in site administration from a dbid.xml file and a restored database and you see the errors in the log below, "Failed to restore project", "Failed to fetch database version". You'll need to ensure the database has proper ownership by your new TD user.
com.hp.alm.platform.exception.CTdException Messages: Failed to Restore Project; Failed to restore project. Failed to fetch database version from sandbox_dev_db; Failed to fetch database version from sandbox_dev_db; Failed to obtain a connection to schema 'sandbox_dev_db'; com.hp.alm.platform.db.CTdDbException: Can't create a new database connection.; Can't create a new database connection.;
Refer to THIS support article for the queries to run to transfer ownership of the project database to a new TD user.