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
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:
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: