My department is currently configuring the Authentication for PL/SQL Developer version 6.0.6.947. We have removed all of the Objects.Drop privileges for some users for database instance 'A'. However, when those users log into database instance 'A' via PL/SQL Developer and right-click on a table, then the 'drop' option unexpectedly still appears on the pop-up menu.
When we do the same for a different database instance 'B', the 'drop' option no longer appears on the table right-click pop-up menu, as expected.
Do you have any ideas as to why the 'drop' option does not go away for database instance 'A'?
We are going to roll this out to 20 users and we don't want them to click on the 'drop' option in the menu, even though it may eventually not allow them to actually drop a table.
Any assistance would be appreciated. Thank you.
When we do the same for a different database instance 'B', the 'drop' option no longer appears on the table right-click pop-up menu, as expected.
Do you have any ideas as to why the 'drop' option does not go away for database instance 'A'?
We are going to roll this out to 20 users and we don't want them to click on the 'drop' option in the menu, even though it may eventually not allow them to actually drop a table.
Any assistance would be appreciated. Thank you.
