• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

application object

How we will see all the application objects in a database....
0
thomasliju
Asked:
thomasliju
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
>>How we will see all the application objects in a database....

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.
0
 
thomaslijuAuthor Commented:
Sorry I want see only the application schema
0
 
slightwv (䄆 Netminder) Commented:
Two ways:
select owner, object_name, object_type from DBA_OBJECTS where owner ='APP_SCHEMA_NAME';

or
log into the schema and use the USER_OBJECTS one above.
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now