View-Option "Check Options for Update"

cibmagic's profile image cibmagic posted 3 years ago in General Permalink

Hi Community,

my apprentice drove me crazy last months, because their SQL-Requests didn't fact the expected results.

Today I realized, that HeidiSQL works very, very different from users with admin-rights. (of course the Trainees have limited rights)

We have a very important database, on which i, even as admin, don't do massive inserts/updates without testing. Therefor we have a 1:1-copy for testing.

This copy contains (even as the original) a view, which does a very Long request to the ACTUALLY used db (=test). There are NO !!!!!! references to the original !

This works proper for all admins.

Today i realized, that this view won't work as proper for my Trainees, because it doesn't read from the ACTIVE db (=test), but from the original. (Their views have 'never ever programmed references')

The difference seems to be, that all admins own the view-option "Check Options for Update=None", the Trainees instead "Check Options for Update=Cascade"

Seems, they miss a right ....

Which ??????

Thanks in advance, Keep healthy

Stephan

ansgar's profile image ansgar posted 3 years ago Permalink

You can compare the whole view code for more differences, probably there is some more:

SHOW CREATE VIEW xyz;
cibmagic's profile image cibmagic posted 3 years ago Permalink

SHOW CREATE VIEW xyz;

Of Course i have checked the view source !

There is definitely NO reference !

ansgar's profile image ansgar posted 3 years ago Permalink

I didn't talk about references, but differences - I would just give it a try and compare both.

Please login to leave a reply, or register at first.