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_at_news.demon.nl>
Date: Tue, 9 Nov 1999 20:49:49 +0100
Message-ID: <942177042.25767.0.pluto.d4ee154e_at_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...Received on Tue Nov 09 1999 - 20:49:49 CET
> 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