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 :

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

Original text of this message