Re: Local synonym visibility in PL/SQL procs

From: Hans Plambeck <hans_at_iris.mincom.oz.au>
Date: 27 Jan 94 21:23:17 GMT
Message-ID: <6758_at_iris.mincom.oz.au>

: CREATE SYNONYM MEMBERSHIP FOR CORE.MEMBERSHIP Easy, can't do a simple 'select * from core.membership' either?

Try: 'GRANT ALL ON MEMBERSHIP TO PUBLIC'

-- 
-----------------------------------------------------------------------------
Hans-J Plambeck | hans_at_mincom.oz.au          | +61 (7) 364 9999, Fax 394 2844
Mincom Pty Ltd. | Juliette St. || P.O.Box 72 | Stones Corner 4120 Qld

Received on Thu Jan 27 1994 - 22:23:17 CET

This message: [ Message body ]
Next message: Hank Griffioen: "Looking for date on ORACLE Book, Graphic and New Report for SGI ?"
Previous message: Kevin Neel: "Re: Local synonym visibility in PL/SQL procs"
In reply to: Mark C. Jones: "Local synonym visibility in PL/SQL procs"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message