All Forums Database
Sandeepyadav 52 posts Joined 09/13
22 Dec 2014
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
 

Thanks, -Sandeep.
Rohan_Sawant 55 posts Joined 07/14
22 Dec 2014

Hi Sandeep Yadav,
Can you please tell the database in which the procedure is compiled?
Thanks,
Rohan Sawant

Sandeepyadav 52 posts Joined 09/13
22 Dec 2014

its PRD_RS_Hst.      and procedure name :  PRD_RS_Hst.ETL_Rolbk

Thanks, -Sandeep.

Rohan_Sawant 55 posts Joined 07/14
22 Dec 2014

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

Sandeepyadav 52 posts Joined 09/13
22 Dec 2014

GRANT SELECT ON prd_DB.Prd_tbl TO PRD_RS_Hst ??
 
but still we are facing the same error msg

Thanks, -Sandeep.

Rohan_Sawant 55 posts Joined 07/14
22 Dec 2014

Hi,

 

Can you share what is stored in "V_QUERY_STMT"?

 

Thanks,

Rohan Sawant

dnoeth 4628 posts Joined 11/04
22 Dec 2014

Hi Sandeep,
you probably didn't set the SP's SQL SECURITY.
Check 
http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00/index.html#page/SQL_Reference/B035_1144_015K/privilege_violations_during_procedure_execution_CREATE_REPLACE_PROCEDURE_SQL.html

Dieter

You must sign in to leave a comment.