
The Open SQL Data Browser is a tool for viewing the content of database tables residing in the system database schema.
Using the Open SQL Data Browser, you can display all data from the table of interest. You can change the set of the columns that are displayed. To restrict the amount of data, you can define search conditions by specifying table and column predicates.
You are in the function of SAP NetWeaver Administrator.
Your user account has permissions to read data from system DataSource tables.
To be able to read system DataSource tables, you must have defined a User Management Engine (UME) action for the desired tables, and assigned the UME action to the role or group your user account belongs to.
For more information, see:
Assigning Principals to Roles or Groups
In addition, the “Example” section below provides source code examples on how to define the UME action.
Displaying Data Using Table and Column Predicates
Select Specify a table and optional column predicates from the Data Access Method dropdown list.
Enter a valid table name in the Show field, then choose the Go pushbutton.
You can also search for a particular table:
Choose the
pushbutton.
Using wildcards, enter a search string in the Table name field, then choose the Go pushbutton.
In the result list, select the table of interest.
The Open SQL Data Browser displays the content of the selected table.
To display in details the content of a particular row, select the row.
To include or exclude particular columns from the table view, choose Column List , then select or deselect the desired columns, and choose Go .
To change the maximum number of the displayed entries, type a value in the Maximal Number of Hits field, then choose the Go pushbutton.
Specifying Search Conditions
You can restrict the table rows by defining predicates on the table columns.
Choose the Search Condition pushbutton.
Select the Create New Predicate radio button.
Specify the predicate arguments using the Column , Predicate Type and Value fields.
Choose the Add pushbutton.
The new search condition predicate appears in the Predicates table.
If necessary, add more predicates.
To edit/remove a predicate:
Select the predicate.
Select the Update/Remove selected Predicate radio button.
To edit the arguments of the predicate, specify the desired values, using the Value field, then choose the Update pushbutton.
To remove the predicate, choose Remove .
To see the number of entries that meet the search condition, choose Number of Entries .
To display the filtered table content, choose Go .
Changing the Settings of the Open SQL Data Browser
Choose the Settings pushbutton.
You can change the following types of settings:
Data Truncation - specify how the read data should be handled
Result Display - customize the layout of the displayed result
Detailed Result Display - customize the layout of the displayed detailed result
Open SQL for Java related settings
Defining UME Actions
When you implement an application that defines actions which describe which tables can be accessed by the Open SQL Data Browser, you can use the following code examples.
An action “MyAction” allows browsing three tables: “MyTable1” , “MyTable2” , and “MyTable3” . Note that such enumeration must be a comma separated list, without spaces.
<ACTION NAME="MyAction">
<PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable1,MyTable2,MyTable3" />
</ACTION>
Another representation with the same effect would be the following:
<ACTION NAME="MyAction" >
<PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable1" />
<PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable2" />
<PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable3" />
</ACTION>
To allow access to all tables with one and the same name prefix, you can use a wildcard. The prefix is a sequence of characters that contains at least an underscore.
<ACTION NAME="MyAction" >
<PERMISSION CLASS="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTablePrefix_*" />
</ACTION>