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
please help on this
you probably didn't set the SP's SQL SECURITY.