Use this dialog to search for and select the database user or role (or Oracle Applications responsibility) which you want to display privileges, query limits and scheduling limits. For example, to narrow your search you might want to list only database usernames that begin with the letter C.
This dialog is also displayed as:
For more information, see:
Use this drop down list to specify whether to search for users or roles (or Oracle Applications responsibilities).
Use this drop down list to specify how you want to match against the value that you type in the Search for field. For example, to find all database usernames starting with the letter T, choose Starts With and type T in the Search for field.
Use this field to enter the text that you want to search for. For example, to find all database usernames starting with the letter T, type T and choose Starts With from the Search by drop down list. You can also use the wildcards % and _. For example, if you enter the text N%, Discoverer Administrator will search for all usernames that start with the letter N. However, if you enter N_T, Discoverer Administrator will search for usernames that start with N and where the third letter of the username is T.
Use this check box to specify whether you want to match upper and lowercase letters exactly when searching (for example, when selected, the search term 'New York' would find 'New York', but would not find 'NEW YORK', 'new york', or 'new York').
Use this button to start the search according to the search criteria that you have specified and display matching values in the Results list below.
Use this button to start the search according to the search criteria that you have specified and display matching values in the Results list up to a maximum of 100,000 rows. The maximum number of rows displayed here is determined by the Registry setting MaxNumListRows (for more information, see "What are the Discoverer Administrator and Discoverer Desktop registry settings?").
If you click Go when the Search for field is empty, all users/roles specified by the Search In value are displayed.
This list displays the results of the search. Use this list to select a database user (or role). Select a name in the list and click OK.
Discoverer displays an error message if the number of rows returned from a search exceeds 10,000 (for more information about changing this limit, see "What are the Discoverer Administrator and Discoverer Desktop registry settings?").