Online Dictionary Options dialog

Use this dialog to specify what types of tables and views you want to see in the "Load Wizard: Step 2 dialog". For example, you can display all tables and views accessible to a user, not just those owned by a user.

For more information, see:

"What is the Load Wizard?"

Which tables (and views) do you want to see?

• Tables owned by user

  Use this option to make available tables and views that belong to the user IDs specified in "Load Wizard: Step 2 dialog".

  Choose this option:

  • When you have a schema, and you want to load tables or objects based on the schema permissions.

  • When you have a schema owner, and you want to load tables or objects based on the schema grants. For example, an owner such as FINAPPS, who owns all of the data tables used by the Financial Applications system and has granted access rights to other users to view those tables.

• Tables accessible by user

  Use this option to make available tables and views to which the user IDs have been granted SELECT access in the database.

What types of tables (and views) do you want to see?

• Public tables

  Select this check box to import tables and views in the selected user IDs' schema that have been granted public access. For example, JOE is seeing publicly accessible tables.

• Partially restricted tables

  Select this check box to import the tables and views in the selected user IDs' schema that have also been granted some access to another user ID. For example, user ID Bob could grant SELECT privileges on Table D in the database to user ID Betty. Table D would be designated as a partial access object. Use this option to display a list of partial access objects that are either owned by a user ID or objects to which the user ID has been given explicit SELECT access. For example, JOE has been granted specific access to these tables.

• Private tables

  Select this check box to import the tables and views in the selected user IDs' schema that are not accessible by any other user ID.

Notes

• A user ID can own tables and also grant access to other user IDs. For example, an application owner, such as FINAPPS, owns all of the data tables used by the Financial Applications system and has granted access rights to other users to view those tables.