Re: Can I Assign A Synonym To A Role?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 1 Sep 1999 15:24:56 +0200
Message-ID: <7qj9gh$din$1@oceanite.cybercable.fr>

I'm afraid you cannot create a synonym for a role. You can only create a synonym either public or in a schema.

On the other hand, you can create a public synonym but grants select on the table only for the role. So only the users that have the role granted can access the table.

simonpeterbeck_at_my-deja.com a écrit dans le message <7qj7nn$fs7$1_at_nnrp1.deja.com>...
>Hi!
>
>I have created a table, MYUSER.MYTABLE, and a
>role, MYROLE.
>
>I would like to create a synonym for
>MYUSER.MYTABLE that would be available to any
>user granted the role MYROLE.
>
>I tried CREATE SYNONYM MYROLE.MYTABLESYN FOR
>MYUSER.MYTABLE but this failed with the
>error "ORA-01917:user or role '' does not exist".
>
>I would like to avoid creating a public synonym
>(i.e. CREATE PUBLIC SYNONYM MYTABLESYN FOR
>MYUSER.MYTABLE).
>
>Is what I want to do possible?
>
>Thanks,
>Simon
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Sep 01 1999 - 08:24:56 CDT