thomasliju
asked on
application object
How we will see all the application objects in a database....
ASKER
Sorry I want see only the application schema
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ALL objects in the database not owned by SYS and SYSTEM:
select owner, object_name, object_type from DBA_OBJECTS where owner not in ('SYS','SYSTEM');
A specific users objects:
select object_name, object_type from USER_OBJECTS;
everything a user has been given access to:
select owner, object_name, object_type from ALL_OBJECTS;
That said: You need to know the application and what schemas and objects it uses. There really isn't a way to tell just by looking at the objects.
Typically all application objects are owned by a common schema but not always.
Some 'bad' developers and DBA's create objects in the SYS and SYSTEM schemas. There really isn't a way to find those.