Browser question :: for the specialists out there ..
From: Neill Atkins <neill_at_firstwrd.demon.co.uk>
Date: Sat, 20 Jun 1998 22:14:04 +0100
Message-ID: <898377498.13542.0.nnrp-06.c2de37a5_at_news.demon.co.uk>
Question :
Neill Atkins .. Email : neill_at_firstwrd.demon.co.uk
Date: Sat, 20 Jun 1998 22:14:04 +0100
Message-ID: <898377498.13542.0.nnrp-06.c2de37a5_at_news.demon.co.uk>
Question :
Being schema X, I used to have access to objects in Schema Y via public grants and public synonyms ..
Objects owned by Y, moved to owner Z, and grants were made to a role - granted to both X and Y. Public synonyms remain, although they point to Z.
Browser queries (X) fail, as objects in Y no longer exist !!
I am (that's me personally) unable to reconfigure the queries to point at Z (should I have to as grants and synonyms exist) ??
AND does browser utilise grants made to roles ? Or do I need explicit PUBLIC or PRIVATE grants to be able to see these objects ??
Awaiting your help (with a broken production system) ..
Neill Atkins .. Email : neill_at_firstwrd.demon.co.uk
First Word Software Limited
Us & Our Opinions Only etc etc ...
Received on Sat Jun 20 1998 - 23:14:04 CEST