Can't run PL/SQL Developer

[jrow]

This is probably a newbie question, but when I run PL/SQL on a particular user I get the following alert message.
"You are not allowed to use PL/SQL Developer on this database.

You do not have the system.logon privledge in the PL/SQL developer authorization table."

The user has DBA and RESOURCE roles. What/Where is the "PL/SQL developer authorization table?"

How do I grant access to this user?

Thanks - JR

 

[Marco Kalter]

This indicates that somebody used the Authorization function as a DBA user, and has created an authorization table. Because it is probably empty now, nobody (except SYS) can use PL/SQL Developer. The customer will need to start PL/SQL Developer under the SYS account again, go to File > Authorization, and press the "Drop table" button. They can also grant the "All" privilege to "PUBLIC".

For more information, see chapter 22 in the User's Guide.