Select User/Role dialog

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:


Select User dialog

For more information, see:

"About Discoverer task privileges"

"Privileges dialog: Privileges tab"

"Privileges dialog: Query Governor tab"

"Privileges dialog: Scheduled Workbooks tab"

Search in

Use this drop down list to specify whether to search for users or roles (or Oracle Applications responsibilities).

Search by

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.

Search for

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.

Case Sensitive

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').

Go

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.

Results

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.

Notes