Users who have been assigned the AccessSQL server permission can execute the following DBM commands:
DBM Command |
Description |
---|---|
Updating the optimizer statistics automatically |
|
Opening a database session |
|
Executing an administration command or an SQL statement (displaying the complete result list) |
|
Executing an administration command or an SQL statement (displaying the result record-by-record) |
|
Scrolling through the results of an administration command or a database statement (displaying the list of results) |
|
Scrolling through the results of an administration command or a database statement (displaying the list of results) |
|
Ending a database session |
|
Opening an SQL Session |
|
Executing an SQL statement (displaying the complete result list) |
|
Executing an SQL statement (displaying the result record-by-record) |
|
Scrolling through the results of an SQL statement (displaying the complete result list) |
|
Scrolling through the results of an SQL statement (displaying the result record-by-record) |
|
Displaying the structure of a result set |
|
Restoring a damaged index |
|
Ending an SQL session |
|
Updating the optimizer statistics |
|
Updating the optimizer statistics as per system table SYSUPDSTATWANTED |