Hi,
I looking for features which, at my look, would be nice:
1. When someone have restricted access to a table (with column-ed
restrictions), doing 'select * from ...' must expand '*' to un-restricted
columns only, not to all;
2. As I understand, table lock prevents access to locked table from other
connections, so if I lock table 'table1' and uses it in 'select * from
table1 t1, table1 t2 ...' nobody else will have access (read or write,
depends on lock type) to locked table 'table1'. So, question is: Why I must
specify table alias in LOCK TABLES command to lock tables for which I uses
aliases?
WBR,
Paul.
