Sorry if this has been covered, but I could not find enough information when I searched.
We have several Owners in our database which are used for SQL Views. During the dump and load process, none of these Owners and Views were recreated, not to mention table permissions.
Is there a utility or process to handle these beyond using Proenv, SQLExplorer, as covered in this knowledge base? Progress KB - How to dump SQL-92 privileges
I am concerned we will miss some rights, because our company has hundreds of customers with their own databases. I am looking for an automated process or script.
Thank you!
We have several Owners in our database which are used for SQL Views. During the dump and load process, none of these Owners and Views were recreated, not to mention table permissions.
Is there a utility or process to handle these beyond using Proenv, SQLExplorer, as covered in this knowledge base? Progress KB - How to dump SQL-92 privileges
I am concerned we will miss some rights, because our company has hundreds of customers with their own databases. I am looking for an automated process or script.
Thank you!