synonym [message #1292] |
Thu, 18 April 2002 04:19 |
youcef
Messages: 5 Registered: February 2002
|
Junior Member |
|
|
Can I create a synonym for a table TA belongs in a schema A ,from an other schema B?
The schema B has only a grant to select a table TA .
Is it suffisent a grant select to create a synonym?
create synonym schemaB.TA for schemaA.TA.
|
|
|
Re: synonym [message #1293 is a reply to message #1292] |
Thu, 18 April 2002 04:40 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
Hello,
the schema B user should have "create any synonym" privilege to create a synonym in another schema. The "create synonym" privilege gives the rights to create synonyms in the users own schema.
Success,
epe
|
|
|
Re: synonym [message #1296 is a reply to message #1292] |
Thu, 18 April 2002 09:08 |
Anthony
Messages: 48 Registered: September 2000
|
Member |
|
|
I thought it was only
create public synonym
or
create synonym for userX.syn_name
but I am not expert, only interested to find out a bit more.
regards
|
|
|
Re: synonym [message #1300 is a reply to message #1296] |
Thu, 18 April 2002 11:20 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
If you want all schema's to see the synonym (public) you have to have CREATE_ANY_SYNONYM and use the command:
create public synonym SYNNAME for schema.object;
If you want private synonyms (only the schema that creates it sees it) you have to connect as that user/schema (CREATE_SYNONYM comes with the CONNECT role or has to be granted to the user) and enter:
create synonym SYNNAME for schema.object;
|
|
|