Hello,
On Mittwoch, 9. Oktober 2002 11:55, Ian wrote: > This is probably a really easy one but I just converted an MS SQL Server > DB to Sap and the conversion went ok. I have a user called dba which is > the database administrator but everytime I use the ODBC driver to > connect to the sap db. My tables are coming back in the form of > dba.tablename > > Hence a table by the name of "extensions" is no longer extensions but > dba.extensions > as long as the logged in user is not the owner of the tables, their names are qualified with the owner's name as schema. If you can or will not log in as the owner, you may create synonyms, as changing the schema is not possible with sapdb. So you have to connect as the one using the tables and then issue: create synonym extensions for dba.extensions and the like for any other table you want to use. Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
