15.00 - Manage Missing Access Privilege Errors - System Emulation Tool

Teradata System Emulation Tool User Guide

prodname
System Emulation Tool
vrm_release
15.00
category
User Guide
featnum
B035-2492-034K

Manage Missing Access Privilege Errors

Teradata SET export, import, and undo operations might be unsuccessful if the logged‑on user has insufficient access privileges. Use the Grant access privilege dialog box to manage a missing‑access‑privilege error. (See also “Error‑Handling Options” on page 57for more information about the Options dialog box.)

Note: When the Submit grant statement from administrator’s session check box is selected in step 4, the check‑box setting and the database session selected in step 4 apply the next time the Grant access privilege dialog box appears.

To retry the failed statement

Use this procedure only if the logged‑on user has permission to grant privileges or a System Administrator is present to grant privileges. See “To ignore missing access privileges”on page 140.)

1 When the Grant access privilege dialog box appears, displaying the missing‑access‑privilege information, click Failed Statement to view the SQL causing the error.

2 Click Retry to retry the failed statement when the required access privileges have been granted using a application other than Teradata SET.

3 [Optional] In the Grant Statement box, enter the grant statement with the missing access privileges.

Note: If the Grant Statement box is left empty, Teradata SET automatically generates the grant statement with the required access privileges.

Select the Grant missing access rights without prompting check box to grant further missing privileges without prompting the Grant access privilege dialog box.

4 Select the Submit grant statement from administrator’s session check box.

A dialog box appears, allowing entry of logon information. Which dialog box appears depends on the connectivity type in use.

5 Enter logon information:

  • For ODBC connectivity, enter logon information in the Select a Data Source dialog box.
  • For CLI connectivity, enter logon information in the Connect to Teradata Database dialog box.
  • Note: The user ID entered must have the right to grant access privileges.

    6 Click OK.

    7 Click Grant to grant the missing access privilege.

    To ignore missing access privileges

    The access privilege error can be ignored or the current operation can be aborted instead of granting the access privilege. (To grant access privileges, see “To retry the failed statement”on page 139.)

    ✔ When the Grant access privilege dialog box appears, displaying the missing access privilege information, click one of the following:

  • Ignore, to ignore the missing‑access‑privilege error
  • Ignore All, to ignore all future missing‑access‑privilege errors
  • Abort, to abort the current operation