Filtering Objects by Ownerships

The program can show Ownership property of objects, and filter objects (like tables, procedures, functions) by their Ownership.

Each database object is owned by either a user or a role. If the owner is a role, the object is co-owned by every user belonging to that role.

(Each object also has privileges associated with it. A privilege grants a particular authority to an object for either an individual user or for all users belonging to a particular role.)

To set on an option 'Show Ownership of database objects' follow these steps:

• Click menu item Tools -> Options.
• Select tab "Show Owners".
• Check on the checkbox with caption "Show Ownership of database objects" by clicking it or by selecting it and pressing space bar on the keyboard.
• Close "Options" dialog box.

After that, two additional combo boxes will show up on left and right panel, as shown on the image below. Now you can filter displayed objects by their ownerships by selecting desired owners from combo boxes.

To set off an option "Show Ownership of database objects", uncheck the checkbox "Show Ownership of database objects" on "Options" dialog box.