Select Access Error in Procedure

Database
Teradata Employee

Select Access Error in Procedure

Hi All,

We are running a procedure and getting an error :" ETL_Rolbk:user does not have SELECT access to prd_DB.Prd_tbl.prd_colmn"

user has all the rights on the prd_db database.

internaly it is calling other procedure

CALL DBC.SysExecSQL(V_QUERY_STMT);

please help on this

6 REPLIES

Re: Select Access Error in Procedure

Hi Sandeep Yadav,

Can you please tell the database in which the procedure is compiled?

Thanks,

Rohan Sawant

Teradata Employee

Re: Select Access Error in Procedure

its PRD_RS_Hst.      and procedure name :  PRD_RS_Hst.ETL_Rolbk

Re: Select Access Error in Procedure

Hi,

Try granting "PRD_RS_Hst" SELECT access to prd_DB.Prd_tbl. i am quite sure your error will be solved.

Thanks,

Rohan Sawant

Teradata Employee

Re: Select Access Error in Procedure

GRANT SELECT ON prd_DB.Prd_tbl TO PRD_RS_Hst ??

but still we are facing the same error msg

Re: Select Access Error in Procedure

Hi,

Can you share what is stored in "V_QUERY_STMT"?

Thanks,

Rohan Sawant

N/A

Re: Select Access Error in Procedure