Hi,

> I would like to deny access to the user the view ddl of objects the
> database
> (views, procedures, tables) and list only objects granted.
>
> Is it possible?

No, that is, tables etc can always be viewed, the actual Stored Procedure,
Trigger, View and Check Constraint code can be removed from the database
by updating the system tables.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com