Can I Assign A Synonym To A Role?

From: <simonpeterbeck_at_my-deja.com>
Date: Wed, 01 Sep 1999 12:55:26 GMT
Message-ID: <7qj7nn$fs7$1@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 - 07:55:26 CDT