Hello All,
I just ran into a rather odd problem in SQL Studio and I was hoping someone could clear the air.
I have two users, DBA, and DBA2. I also have 2 tables FOO and BAR. FOO belongs to DBA and BAR belongs to DBA2. DBA has all privileges on DBA2's tables and vice-a-versa.
Now: In sqlcli I can use the create synonym statement to create a synonym like this.
sqlcli -d <dbname> -u DBA,password
sqlcli on <dbname>=> CREATE PUBLIC SYNONYM S_BAR for DBA2.BAR
This works. However whenever I try to do this in SQL Studio, I get an error: (logged in as DBA)
Auto Commit: Off, SQL Mode: Internal, Isolation Level: Committed Base table not found;-4004 POS(38) Unknown table name:BAR.
CREATE PUBLIC SYNONYM "S_BAR" FOR "BAR"
Obviously the problem is that SQL Studio isn't specifying the correct syntax for the table BAR. So this is a scoping problem. Is this the intended functionality of SQL Studio? Or are there plans to fix this? This problem isn't in WEB PTS, so I assume no one has experienced this?
Any help would be greatly appreciated.
Cheers, JLS
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
