want ability to desc, but not select/insert/update/delete

Any security set-up recommendations which would allow a developer account to describe a table in another schema, but not select/insert/update/delete?

Ideally the developers would be able to use Oracle EM Schema Manager or a reverse engineering tool to get at the full table definition (including constraints), but not be able to write applications directly against that schema. As background, we're modifying an existing database and the developers need to reference a controlled original database version, but do work on another version.

Thanks,
Brian Gastineau

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 19 1999 - 15:16:21 CST