A call to OracleCommandBuilder.DeriveParameters in my application is
throwing the above Oracle error. The stored procedure within the
command exists, so it must be a permissions issue. The .NET app
connects to SchemaA, which has a stored procedure that references a
table in SchemaB. SchemaB's user has granted SELECT to the table and
created a public synonym but the error still occurs.
I assume its a data dictionary thing; it works if I grant DBA to SchemeA but I don't want to do this.
Does
anyone know to what table/view in SchemaB I need to grant SchemaA or
what system privilege SchemaA needs to perform an
OracleCommandBuilder.DeriveParameters?
J.