Can't logon 9205 DB

[neil_tw]

I had upgrade my PROD database to 9.2.0.5. But I can't logon the PROD database via PL/SQL Developer 6.0.3. But can logon TEST database which version is 9.2.0.5 too. I use the database default value and no any modifies at two enviroment!

 

[Uli Kobsa]

Could you provide some more information, please?What is the error message you get? Can you connect to your PROD DB via plain SQL Plus?

greetings,
Ulrich

 

[neil_tw]

My enviroment information are:
OS IBM AIX5L, Can connect PROD DB via plain SQL*Plus.
ERROR:
You are not allowed to use PL/SQL Developer on this database.
You do not have the System.Logon privilege in the PL/SQL Developer authorization table.

Regards,
Neil

 

[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. You will need to start PL/SQL Developer under the SYS account again, go to File > Authorization, and press the "Drop table" button. You can also grant the "All" privilege to "PUBLIC".

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

 

[neil_tw]

This problem was fixed after drop the sys.plsqldev_authorization of PROD env.
Thanks ALL!
----------------
Neil