OneWorlded
Member
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
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