7. Changing Ownership of Databases and Database Objects : Changing Ownership of a Database Object : Changing Ownership of Reports : Example: Transfer Ownership of Reports to Another User
 
Share this page                  
Example: Transfer Ownership of Reports to Another User
Assume the user john wants to transfer ownership of the reports named parts_restock and parts_on_order in the database mydb to the user dba. The following commands, entered at the operating system prompt, accomplish this:
copyrep ‑ujohn ‑f  mydb text.rw parts_restock parts_on_order
sreport ‑udba mydb text.rw
For a complete description of the flags and parameters for copyrep and sreport, see the Forms-based Application Development Tools User Guide. These commands are also described in the Command Reference Guide.
At this point, there are two copies of each report, one owned by the user john and the other owned by the user dba. In the usual case, John’s reports are no longer needed and can be removed in Report-By-Forms.