Re: Help needed on DBMS_SQL

From: EXE <exe_at_exesolutions.com>
Date: 1998/08/16
Message-ID: <35D7D460.A7D01420_at_exesolutions.com>#1/1

> I try to use dbms_sql to create a synonym.

The other responses I have seen to your query are on target but I would add one other thing to check. When using dynamic SQL it is often necessary to have the ALL privilege as in CREATE ALL SYNONYMS; not just CREATE SYNONYM depending on what you are trying to do..

Regards,

Daniel A. Morgan Received on Sun Aug 16 1998 - 00:00:00 CEST

This message: [ Message body ]
Next message: Madhu Cherukuri: "Lsnrctl80 problem in Windows98"
Previous message: José Nicolau: "Re: Export"
In reply to: Maarten Scharroo: "Help needed on DBMS_SQL"
Next in thread: Marcel Claus: "Re: underline"

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

Original text of this message