"ORA-01031: insufficient privileges" error when trying to insert in another schema using dynamic sql
Hi,
I get "ORA-01031: insufficient privileges" while trying to insert a row into a table in another schema using dynamic sql...
the table is in the the schema 'Studio'
and i'm trying it from the user 'Web'
I granted the user web all privileges directly on the table and there is a public synonym for the table
I can insert a row as user web into the table using regular sql, i just get this error trying to do it using dynamic sql
the dynamic sql statement is in a package in the web schema, and when I add "AUTHID CURRENT_USER" in the header of the package I
I get "ORA-01031: insufficient privileges" while trying to insert a row into a table in another schema using dynamic sql...
the table is in the the schema 'Studio'
and i'm trying it from the user 'Web'
I granted the user web all privileges directly on the table and there is a public synonym for the table
I can insert a row as user web into the table using regular sql, i just get this error trying to do it using dynamic sql
the dynamic sql statement is in a package in the web schema, and when I add "AUTHID CURRENT_USER" in the header of the package I
0