[Info-ingres] Behaviour change on schema.table_name

[Karl and Betty Schendel]

On Aug 27, 2019, at 5:47 AM, Martin Bowes <martin.bowes at ndph.ox.ac.uk> wrote:
> 
> Eg. In database ddd owned by user downer, a user u1 has a table t1 on which they have granted group g1 select access.
>  
> Another user (u2) connects to the database specifying the –Gg1 connection attribute.
>  
> They select * from t1;
>  
> In 10.1 and 10.2 the user would get data from u1.t1
>  
> In 11.1 the query fails with E_US0845 Table 't1' does not exist or is not owned by you.

This is real close to "I don't believe it" territory.  Group membership has zero
implication for the schema search path, and in fact the parser in general
has no idea what group the session is running in.

If that's how it worked in 10.x, I bet it was purely by accident.  (I can't
look at the code right this moment to see.)

Karl