Synonym for TYPE(URGENT) [message #38585] |
Mon, 29 April 2002 07:40 |
ranjan
Messages: 20 Registered: August 1999
|
Junior Member |
|
|
Hi
Is is possible to create synonym for a oracle type.
If not then can you suggest how to use from a schema types created in different schema...
Ranjan
|
|
|
|
|
Re: Synonym for TYPE(URGENT) [message #38654 is a reply to message #38585] |
Fri, 03 May 2002 07:41 |
Yogita
Messages: 8 Registered: April 2002
|
Junior Member |
|
|
Check the privilege.
To create a private synonym in your own schema, you must have CREATE SYNONYM system privilege.
To create a private synonym in another user's schema, you must have CREATE ANY SYNONYM system privilege.
To create a PUBLIC synonym, you must have CREATE PUBLIC SYNONYM system privilege.
|
|
|