TOAD question

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Fri, 8 Dec 2000 15:17:55 -0800
Message-Id: <10704.124123@fatcity.com>

Hi!

We are having an application that is owned by the user APP.

I granted select and update privileges on APP's objects to the developers who need it. Others were only given select privileges. Then I created public synonyms for APP's objects.

So when a developer logs into SQL Plus and queries one of APP's tables (i.e. the syononym) everything works fine. But when they log into TOAD, they can easily switch schemas by selecting APP's schema in the drop down list and have a look at APP's tables.

They get an error message "insufficient privileges" when they try to insert a row in a table.

Would there be any way in TOAD to prevent those guys from even selecting the APP user from the drop down list? They shouldn't even know that the tables belong to the APP user.

Any ideas? Received on Fri Dec 08 2000 - 17:17:55 CST