Failure 7977 'Grant' operation on 'QGEXECUTEFOREIGNQUERYCONTRACT' not allowed.

QueryGrid
Teradata Employee

Failure 7977 'Grant' operation on 'QGEXECUTEFOREIGNQUERYCONTRACT' not allowed.

Running into the following when executing FFE as `DBC`:

 

```*** Failure 3523 DBC does not have EXECUTE FUNCTION access to TD_SYSFNLIB.QGEXECUTEFOREIGNQUERYCONTRACT.

GRANT EXECUTE FUNCTION on TD_SYSFNLIB.QGEXECUTEFOREIGNQUERYCONTRACT to DBC;

*** Failure 7977 'Grant' operation on 'QGEXECUTEFOREIGNQUERYCONTRACT' not allowed .```


Accepted Solutions
Teradata Employee

Re: Failure 7977 'Grant' operation on 'QGEXECUTEFOREIGNQUERYCONTRACT' not allowed.

'TD_SYSFNLIB.QGEXECUTEFOREIGNQUERYCONTRACT' should be changed to:

 

'TD_SYSFNLIB.QGEXECUTEFOREIGNQUERY'

 

Then:

 

GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGEXECUTEFOREIGNQUERY TO dbc

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: Failure 7977 'Grant' operation on 'QGEXECUTEFOREIGNQUERYCONTRACT' not allowed.

'TD_SYSFNLIB.QGEXECUTEFOREIGNQUERYCONTRACT' should be changed to:

 

'TD_SYSFNLIB.QGEXECUTEFOREIGNQUERY'

 

Then:

 

GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.QGEXECUTEFOREIGNQUERY TO dbc