Hi,
Just playing around here trying and 'confused' what the GRANT USAGE ON SCHEMA is supposed to be for?
I thought it was supposed to all 'full' access of one schema to the other
I have created 2 schema a, b and I did
grant usage on schema a to b
grant usage on schema b to a
I tried to select tables from one to the other and it is giving permission denied until I have to do the grant below.
grant all on all tables in schema a to b ;
grant all on all tables in schema b to a ;
Is this expected behavior? Or does the GRANT USAGE only allows switching between schema?
Regards,
Edd