Re: Synonyms
From: SquidKiller <alan_vervaeke_at_technologistNOSPAM.com>
Date: Wed, 29 Apr 1998 09:58:48 -0400
Message-ID: <6i78b8$gdb_at_news9.noc.netcom.net>
Date: Wed, 29 Apr 1998 09:58:48 -0400
Message-ID: <6i78b8$gdb_at_news9.noc.netcom.net>
Michael Krolewski wrote in message <3546A7F7.1C2B3F5C_at_u.washington.edu>...
>
>No that is not so. You need one synonym per table per role. All users
>associated with that role have access to the synonym. You can associate a
>synonym to a user or a role.
>
Sorry, Mike, but that is absolutely wrong. You can create private synonyms
or Public synonyms, but a synonym may not be associated with a role. Elaine
would be better off with Public synonyms, but only grant privileges via
roles. All those private synonyms are a pain.
Alan Vervaeke Received on Wed Apr 29 1998 - 15:58:48 CEST