Need Help
Posted: Tue 11 Jan 2011 12:34
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
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