Hello,
Getting below error while running live plan for SQL.does DPA DB user should have select access on all app schema or any specific previlege
Hello,
Getting below error while running live plan for SQL.does DPA DB user should have select access on all app schema or any specific previlege
The query has an unqualified table name, so the Live plan will try to use your DPA user as the default schema name for the table i.e. <DPA_user>.OA_CUSTOMER_DTL which (apparently) does not exist.
I don't have Oracle, but when you do a Live Plan for other DBMS you may get prompted for a schema name - use the appropriate one and it should work.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.