>HI,
>Is there a way to findout if an object (eg a table) has been created or dropped by a user?
>
>Thank you,
>Christian Cote
Not retro-actively other than to see if a table specifically exists. For an app, no user should have create or drop table privs for the app tables. They should only have those privs for tables they create under their own schema [user ID]. All objects for an app should be created under their own app schema. You then can create roles that grant various Insert, Update, Delete privs then grant appropriate role[s] to the users of the app.
To track who create or drops what tables, there is an AUDIT TABLE CREATE, TABLE DROP, ... command. This needs to be coordinated/done by the Oracle DBA.
Mark McCasland
Midlothian, TX USA