Re: "OWNER.TABLE" problem...

On Thu, 4 Feb 1999 16:54:41 +0100, Chris Totten wrote (in message <F6n075.KHK_at_cix.compulink.co.uk>): snip
> SELECT * FROM X
>
> ...doesn't work...
>
> SELECT * FROM OWNER.X
>
> ...does work...!

snip
> Is there any way to save us from prefixing the table names in this way? Is
snip

Hi Chris,

the normal way to go is to create [public] synonyms for all the tables and views that should be visible to the users. By granting the privileges to the roles and the roles to the users you just gave them permission to use the tables. Without the synonyms they still are 'invisible' to them.

have luck,
--

Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html

        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl