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

From: Nathan Christiansen <nathanc_at_itsnet.com>
Date: Tue, 09 Nov 1999 12:45:08 -0700
Message-ID: <382879C4.29CE750E@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:45:08 CST