...not alldowed to use PL/SQL dev. on this database

[Bugenahnen]

When I'm starting PL/SQL Developer after giwing user basse name an dpassword an error pops up:
"You are nt allowed to use PL/SQL Developer on this database"
It's strange cuz it's showed that I'm cocneccted to the database. Moreover, when I'm running SQLplus from Start... everything works fine. What's the problem??

 

[Kirurgs]

It seems your DBA cheks what application connects to DB and when it's plsqlde.exe then raises an custom exception.

 

[Bugenahnen]

That's odd.Very odd.
I installed this developer on friday and WORKED on it. Without roblems.
More: I've got another computer right by my side on which developer was working as well (on friday, and today it crashes too.
Never mind. Could you tell me how to disable the option, so that the DBA won't raise an exception?
( I'm rater beginner with Oracle and databases)

 

[Bugenahnen]

That's odd.Very odd.
I installed this developer on friday and WORKED on it. Without roblems.
More: I've got another computer right by my side on which developer was working as well (on friday, and today it crashes too.
Never mind. Could you tell me how to disable the option, so that the DBA won't raise an exception?
( I'm rater beginner with Oracle and databases)

 

[TenGor]

Hy,

do you use Version 6?
Because there you can authorizice what each user can do on a DB.
You can reach this options over the Menu (after a login to the DB)
File->Authorization...
Or look (and perhaps drop?) the table "sys.plsqldev_authorization"

 

[Bugenahnen]

Yes I'm using 6.0...
And if I wanted to edit table what should i enter in column named GRANTEE?
( it's empty !!- still on the other computer swith dev 5.0... is working)

 

[Marco Kalter]

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

 

[Bugenahnen]

Thanks guys. I'm shurely going to check it tomorrow. I hope it works. But anyway, it's still strange. I'm operating on really small and meaningless DB. Doesn't make sense.
Is it possiuble that the table has bee created by dev?, or by the Oracle itself????
It's just my curiosity.

 

[Marco Kalter]

No, it has to be created by a user with DBA privileges, by using the PL/SQL Developer Authorization function.

 

[TenGor]

@marco

but this is exact the same issue which i had a couple of weeks ago.
i'm absolute sure that none of my developers had use this PL/SQL Dev function. (just one installed PL/SQL Dev Vers. 6 in these days)
And from one day to the next, noone could connect to the DB where these table exists. It was empty too!

 

[Marco Kalter]

Did you drop the table? Did the problem happen again?

 

[TenGor]

@Marco
after dropping the problem was gone and it didn't happen again. Since then no developer had installed PL/SQL Dev again...

 

[Marco Kalter]

The installation in itself does nothing to a database. I think someone did it, now knows the consequences, and has not done it again.

 

[TenGor]

@marco

> now knows the consequences, and has not done it again.

This could be right...
But i find it a little unfortunately that, if you open the feature the first time and submit the waring, do nothing and exit it, that no one can connenct any more.

 

[Marco Kalter]

This only happens if you ignore the warning. The problem only occurs if you confirm after the warning.

 

[TenGor]

You're right...
It seems logical. If a user ignores two warnings, no one could help him ;-)