Cannot Open Locked Report

[hsshah]

I have created a bunch of report in PL/SQL developer that points to the 'reporting' instance of our database. I used 'Locked for other users' on these reports with a password. We have some issues with that database and it is down right now. I would like to edit the report to point to another instance of the DB; but because I could not login to the connection stored in the report, it does not allow me to open/unlock the report!! I have tried unlocking it with both query reporter and PL/SQL developer. Is there any solution to this?
Any help will be greatly appreciated.

 

[Marco Kalter]

You can only edit the report when connected to the specified database and the specified user, so you will have to bring the database up again.

 

[hsshah]

Thank you for the reply.

So what does having password do? Is it that in addition to having the connection made, you need password to unlock (for other users)?

Do you think it would be a better functionality if it just asks for the password (irrespective of the connection status)?

Thanks again for your support.

 

[Marco Kalter]

To quote the User's Guide:

The Security options allow you to lock the report definition (the SQL, Layout, and Options), so that a user cannot view or change it. This may be useful if the Connect Parameters specify a privileged account (such as SYS) with password. If a user can change the SQL, he or she could execute any statement under the SYS account if the report is not locked.
The Security can be set to one of the following values:

* Unlocked