Re: Desparate Oracle Help...

"Christopher Burke" <craznar_at_hotmail.com> wrote in message news:Xns9151ADF189615craznar_at_130.102.2.1...
> OK, I have spent 8 hours on this one ... anyone help?
>
> I have a user 'joe' which has a whole stack of tables, I have a user 'bob'
> which can access those tables.
>
> I need to make it so that 'bob' can access the tables using the same
syntax
> as 'joe'.
>
> That is 'joe' can go 'select * from blah', I need 'bob' to be able to do
> that as well instead of 'select * from joe.blah'.
>
> I cannot use VIEWs or SYNONYMS ... they have to be tables when looked at
> from the 'bob' account ... just as they are when 'joe' accesses them.
>
> With VIEWs and SYNONYMs - they are not tables for 'bob', but they are for
> 'joe'.
>
> Any ideas ?
>
> --
> ---
> /* Christopher Burke - Spam Mail to craznar_at_hotmail.com
> |*
> \* Real mail to cburke(at)craznar(dot)com

Why do you think you can't use synonyms? Did you try it at all? Please try creating a synonym
create synonym blah for joe.blah
Now issue a
select * from blah
What is the result?
You are selecting from joe's tables!!!
You're using exactly the same syntax!!
Now issue a select table_name from all_tables where table_name = 'BLAH' What is the resutl?
So ... what is your problem?

Hth,

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address