Hi Team,
I am using version 10g database.I have 3 Schema
1. NET_TKM
2. NET_STG
3. NET_SRC
First connected to (NET_TKM) I have given all the grant to NET_STG
grant all on CB_ACCOUNT_MASTER to NETONE_STG WITH GRANT OPTION;
*out put :- grant succeeded.
Second Connected to (NET_STG) I have created synonym
create or replace synonym CB_ACCOUNT_MASTER FOR NET_TKM.CB_ACCOUNT_MASTER;
*out put :- created
and
grant all on CB_ACCOUNT_MASTER to NETONE_SRC ;
*out put :- grant succeeded.
Three Connect to (NET_SRC) i am creating synonym
create or replace synonym CB_ACCOUNT_MASTER FOR NETONE_STG.CB_ACCOUNT_MASTER;
Getting an error :-
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
*Action: Ask the database administrator to perform the operation or grant
the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label.