How to Hide "Authorization" from File Menu

[Bebop]

Hello,

I'm using the Authorization facility in PL/SQL Developer 6.0.5 and I wonder if there is a way to Hide the "Authorization" section from the File/Menu ?
Because I don't want users to see how security rules are implemented on databases.

It will be interesting in future release, to implement a new rule in order to disable this functionnality.

Thanks in advance for your feedback.
Best Regards.

 

[TenGor]

Hy,

didn't that this feature still exists!
Never searched the full File-Menu...
But I remember that a developer had done something in PL/SQL Developer some weeks aog (he was new in it) an no one could log in PL/SQL Developer after it.
We found this table: sys.plsqldev_authorization and deleted it. After this anyone could log on as before.

He just upgraded from an old 5 to 6 Version and it seems that this table would be generated while installation or first login?

I think this isn't quite good.
It should only be generated if i go to this feature the first time.
So a option in Preferences would be nice.
And there is an ohter point: If i create this table, but add no user/role, am i able to do this after a new login with PL/SQL Developer?
Or must i drop the table over SQL/Plus?

 

[Marco Kalter]

It will be interesting in future release, to implement a new rule in order to disable this functionnality.

I have added this to the list of enhancement requests.

He just upgraded from an old 5 to 6 Version and it seems that this table would be generated while installation or first login?

NO!. You have to explicitly create this table by using the Authorization function, and you must also be connected as a DBA.

And there is an ohter point: If i create this table, but add no user/role, am i able to do this after a new login with PL/SQL Developer?

Yes, if you can create the table, you can also drop it by using the Authorization function, even if no functions have been granted.

 

[Bebop]

So at the moment, there is no solution to hide/disable the list of user/roles allowed to run PL/SQL dev ? Is that ok ?

 

[TenGor]

Originally posted by Marco Kalter:
NO!. You have to explicitly create this table by using the Authorization function, and you must also be connected as a DBA.

Hm, mysterious thing. My Developer says, that he didn't do that. Perhaps he just didn't remember it...

And there is an other point: If i create this table, but add no user/role, am i able to do this after a new login with PL/SQL Developer?
Originally posted by Marco Kalter:
Yes, if you can create the table, you can also drop it by using the Authorization function, even if no functions have been granted.

But if if "start" with the Authorization i get the message, that i can't get into the DB over PL/SQL Developer until i grant privs and roles except i'm SYS. This is just what we had. (we have an other user as DBA).

 

[Marco Kalter]

Perhaps he just didn't remember it...

Well, like you say below, you get a warning before creating the authorization table .

(we have an other user as DBA)

Ah, this seems to be a bug. You will need to connect as SYS to drop the table from within PL/SQL Developer or to grant privileges. We'll fix it.