Re: Confused about Synonyms

Xu Guo Miao (Komix Hui)(Hui kwok Miu) wrote:
>
> Storaged procedures/packages of user A can only reference those objects
> of user B directly granted to A, not through any roles.
> --
> +---------------------------------------------------------------------+
> | Hui, Kwok Miu(Mr.) xgmiao_at_hk.super.net |
> | (Xu, Guo Miao in Mandarin) kkmhui_at_peoplesphone.com.hk |
> | System and Database Administrator Tel: (00852) 2945 8005 |
> | Peoples Telephone Co., Ltd. Fax: (00852) 2845 7757 |
> +---------------------------------------------------------------------+

From the title of your posting, I will assume that user B did not declare the synonym as public, in which case only those users to whom he has explicitly granted access will be able to see those objects - including roles. That is, if he has not granted access on those objects to the role(s) which are attempting to access them, then they will be inaccessible. Your username should still be able to access them, depending on you the application was set up (i.e., if the application identifies you as a role or a user).

-- 
======================================================================
Gary T. Smith                              Phn: (513) 241-5949
Client Server Associates                   Fax: (513) 241-6731
======================================================================