Re: Synonyms

From: Michael S. Abbey <masint_at_istar.ca>
Date: Wed, 29 Apr 1998 02:57:52 GMT
Message-ID: <35469770.168188342_at_news.istar.ca>

On 28 Apr 1998 14:36:50 GMT, en201_at_cus.cam.ac.uk (E. Nunns) wrote:

>
>We have just moved from a user grants configuration to a role based grants
>configuration. Does anyone know how synonyms fit with this configuration.
>
>It looks as if we still need one synonym per table per user, so even a
>fairly small application needs a huge number of synonyms.
>
>Is there anyway that we can create common synonyms for a specific group of
>users (based on the role that they have been given for instance).
>
>Elaine

No.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Wed Apr 29 1998 - 04:57:52 CEST