Wildcards and Help
You can use the asterisk (*) wildcard to specify all or part of the owner or object name parameters in a help statement. The help statement displays only objects to which the user has access, which are:
• Objects owned by the user
• Objects owned by other users who have granted permissions to the user
• Objects owned by the DBA to which you have access
If you specify wildcards for both the owner and object name (*.*), help displays all objects to which you have access. To display help information about objects you do not own, you must specify the owner name, using the schema.objectname syntax. For details about schemas, see the SQL Reference Guide.
If you omit the owner name wildcard (that is, specify * instead of *.*), help displays the objects you can access without the owner prefix. The following examples illustrate the effects of the wildcard character: