Re: How To?: create a user with access to another user's tables, etc.

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 9 Nov 1999 20:49:49 +0100
Message-ID: <942177042.25767.0.pluto.d4ee154e@news.demon.nl>

You need to
a) have MEDGE give at least select privilege on every object to TESTUTILITY b) either CREATE PUBLIC SYNONYM <table_name> for all MEDGE tables or create (private ) synonyms in the user TESTUTILITY.

Hth,

--
Sybrand Bakker, Oracle DBA
Nathan Christiansen <nathanc_at_itsnet.com> wrote in message news:382879C4.29CE750E_at_allencomm.com...
> I have a user named MEDGE that has several tables, functions, procedures,
and views that I need
> another user (TESTUTILITY) to have access to (basically everything that
MEDGE owns).
>
> How do I create or grant the TESTUTILITY user this access without having
to put the owner name
> ("MEDGE.") in front of all of the tables, etc.
>
> I tried giving specific object privileges, but that didn't work.
>
> Please Help!
>
> --
>
> Nathan Christiansen
> Multimedia Programmer
> HTML/Java Group
> Courseware
> Allen Communication
Received on Tue Nov 09 1999 - 13:49:49 CST