Hi,
We can connection to our db using sql developer or sql/Plus with a username and password without problems. However when we try to update a table in another schema using the form schemaname.tablename, we get a login denied error from oracle when using dotconnect.
The line of code was something like:
db.ExecuteCommand("delete from CGSDB.Temp_Prism")
At the same time, I can connect to the database using the database explorer, but it does not show ANY objects. Yet the username does have permissions to a variety of tables and procs from another schema etc.
Is there a way to reference objects in another schema in the explorer?
HELP!!!
Thanks … Ed
Need Help
1. I have tried to reproduce the problem with the 6.0.70 version of dotConnect for Oracle using both Direct and OCI modes. It works OK with the Devart.Data.Oracle.OracleCommand object. I just granted this privilege to the user I opened connection with:
After this, the following command was executed successfully:
2. The "Show All Objects" option is available in Database Explorer that is included into OraDeveloper Tools.
Give us the following information:
1) the version (x.xx.xx) of dotConnect for Oracle you are using. You can find it in the Tools > Oracle > About menu of Visual Studio;
2) the class your db object is instance of;
3) have you tried to grant the DELETE privilege on CGSDB.Temp_Prism to the user you are connecting with via dotConnect for Oracle?
4) give us the exact text of the error and its call stack.
Code: Select all
GRANT DELETE ON CGSDB.Temp_Prism TO name_of_connected_user;
Code: Select all
oracleCommand.ExecuteNonQuery("delete from CGSDB.Temp_Prism");
Give us the following information:
1) the version (x.xx.xx) of dotConnect for Oracle you are using. You can find it in the Tools > Oracle > About menu of Visual Studio;
2) the class your db object is instance of;
3) have you tried to grant the DELETE privilege on CGSDB.Temp_Prism to the user you are connecting with via dotConnect for Oracle?
4) give us the exact text of the error and its call stack.