system.logon privilege

[new2oracle]

Hi all, i was using PL/SQL and i accidently hit on the authorization under 'File' and i could not remember what exactly i clicked after that. I was clicking very fast.

Subsequently i tried to log onto my db and i got an 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".

any remedies?

 

[CTzen]

Disabling authorization

To permanently disable authorization, you can drop the sys.plsqldev_authorization table or delete all records. To temporarily disable authorization, you can either revoke the privileges on the table or rename it (making it invisible to the PL/SQL Developer users). To enable it again later, you can grant select privileges again.

 

[new2oracle]

Slava, thank you. my problem was resolved after i drop the table.