how to change default schema for each user?

[Former Member]

Hello,

i have migrate my database from 7.7 to 7.8 i get a problem that i have to add the schema name dba (my database schema) in every query, is there a solution

Thanks

[thorsten_zielke · Accepted solution]

Hi,

there has indeed been a change from 7.7 to 7.8 in regards to schema name requirements. SAP MaxDB now handles this more strict and requires the schema to be specified.

So, in your case you now have two options:

1. Rewrite all SQL statements by adding the schema name

2. Create a 'public synonym' for each table allowing the table to be queried without schema.

I would expect option (2) to be easier as I assume that you have more SQL statements than tables and you could create all those synonyms at the beginning of your code.

Here is the syntax:

'create public synonym <synonymname> for <schemaname>.<synonymname>'

Thorsten

[Former Member · Accepted solution]

Hi,

Thank you its very useful

regards,

Seif