Re: SQL*REPORTER1.1.14 Questions

Kevin Leung wrote:
>
> 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

A1 : If you store all reports in the system tablespace, it would be a simple REVOKE and GRANT command to swith the report ownership to a new user.

     If you want user storage (SRW2 tables stored under the users domain), you can export all reports with one command:

        dumprep user=scott/tiger reports=% file=all_rep.REX

Loading into another account is just as easy:

        loadrep user=new_scott/new_tiger reports=% file=all_rep.rex

A2: Use the SRW_DROP.SQL script located in ORACLE_HOME/sqlreport/admin to drop all reports in a users account.

Rgds,

Per Brondum
Senior Manager
Product Management Email :
pbrondum_at_us.oracle.com
Developer/2000 Compuserve : 74221,2406 Received on Sat Jan 20 1996 - 00:00:00 CET