grant privilege select on table in another schema via role error
hello
i have a problem with granting privileges for another schema
i have user A , that has only 1 system priv: connect, which has a priv: create session;
i have created a role X, to which i granted privilege: select on a table customers from schema B.
i granted then this role X to user A.
i cannot do select * from B.customers when im conneted to A
id appreciate info what am i missing?
thanks
rgds