i am running dozens of databases for my Company. In fact, there is one, who is "the haert and the Soul" of all.
Once per month i run an import-session from sap over. To prevent any crashes, i use a 1:1-copy of my db for "the first" Import - if this causes no probs, i'll do the Import to the original (ok, there are better ways, but ....)
Fact: The "test"-db is a 1:1 copy of the original, made by heidi-SQL via "Export database as sql"
If I (me, on my Workstation) open this TEST-db (!!!!!!!!) = Copy i see my my views-sources like this (as expected) :
select bla, bla, bla from table join table ... join table (and so on)
if other's (with very much less rights to the Server !!!!) open the same view-source, they see: select bla, bla, bla from ORIGINAL-DB.table join ORIGINAL-DB.table ...
So, any changes in the copy won't affect the views in the copy
I own two Screenshots, which Show the different presentation of the same view-code on two different Clients - working in a Hospital i like not to present them online !
So - does "Export database as SQL" mean, that views allways reference to the orig-db, not to the current db, in this case test-db ????????
Oh my god, what an fucking english - hope you've understand me ....
Best Regards Stephan
Is this NORMALLY for SQL, is it a Problem of Server-Rights ??? or what ?