Refresh data from PD to PY VIA SQL Backup and Restore

I would like some help with refresh data from PD to PY using SQL Server backup and restore function.

Here are the steps that we had performed

1. Backup PD to disk
2. Restore PD to PY
3. Changed objects owner for each table. (PRODDTA to CRPDTA, PRODCTL to CRPCTL)

Problem: The table permission for public is missing (Select, Insert, Delete, Update and DRI).

How do I fix it? Or am I not doing it right?

Thanks

I just did something similar and didn't have any problems. We backed up our Development business data to disk and then restored to a new database. We changed the owners with no problems. We had removed the permissions from public a while ago, but the permissions for the jdeuser role carried over no problem.

Hi,
You need to run a script line to generate lines to grant access to Public on all your tables and then execute these lines afterwards.
Here is the script that I use to create exec lines:

select 'GRANT ALL on ' + name + ' to public'
from sysobjects where xtype = 'U' and uid = xxxxx

All you need to do is to plug the UID of your database , you have one for CTL and one for DATA.

Once the exec lines got created for each table, then you will need to execute them. In order to make it work, you will need to sign in 2 different USERS, one for CTL and one for DATA, to run exec these lines for corresponding tables.

Good luck