Archives of the TeradataForum
Message Posted: Mon, 05 Dec 2005 @ 10:12:11 GMT
I agree that an explain should be run in the production box. But not with the developers user-id!
Because he/she will not be running the query on the production box. Or if so, he/she must have the access anyway.
I don't know if this particular case is for ETL, but when we code ETL-scripts we do the following through our configuration management tool:
Every SQL-statement in the script is EXPLAINed on the production box, using the logon-user that will be used when the script eventually executes in production (a project-user we call this).
This way we can check for syntax errors, AND also that the project-user has the necessary access rights.
So I'm quite pleased with the fact, that Teradata checks access rights when EXPLAINing a query!
Regarding your two choices, number 1 don't make sence, but number 2 does - the user id used should be one with the access rights needed by the production user(s) runnning the query.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|