need clarifications on privs
I have schema A and schema B,i have granted access to schema A on all objects of schema B with grant option ,now if i create any new object on schema B i need to grant access again to schema A,is there anyother way apart from 'grant select any objects' access to dynamically grant access to schema A for all newly created objects of schema B.
Thanks