SQL*REPORTER1.1.14 Questions

Q1. When a user leaves the company, we have to transfer all the SQL*REPORT V1 objects from one account to another. What is the quickest way to do it besides dumprep and loadrep? The user has 100+ reports and she saves all reports to the database.

Q2. When we check out a user, I use the "drop user" command. However, the objects saved in the database like SQL*REPORT V1, SQL*Forms 3.0 nd SQL*MENU 5.0 objects are not being deleted automatically. Is there a simple command to delete all these objects or do I need to manually delete all of them?

Q3. When I do a "exp" to export a user, the database objects like SQL*REPORT, SQL*Form and SQL*MENU do not seem to be in the export file. Why do the other DBA normally backup these objects in case we need to restore them later if we need to drop these objects after someone leaves the company? Do you use dumprep to dump every single reports and create an inp file for every sql*form programs?

Please respond directly to kleung_at_nrel.gov Thanks!

Kevin Leung Received on Thu Jan 18 1996 - 00:00:00 CET