create database link privilege error

Hi there,

when i do sqlplus <schema_owner>/<schema_owner> and attempt to create database links, i get ERROR at line 1:
ORA-01031: insufficient privileges

I opened another terminal and logged in as sqlplus internal. I did GRANT CONNECT TO <SCHEMA_OWNER> and commit followed.

I went back as schema_owner and still cannot create database link

I tried do this as internal once again
  GRANT CREATE DATABASE LINK TO default_admin_role; and commited

  and GRANT default_admin_role to SCHEMA_OWNER has already been done

What is that iam missing here ???

-your help is appreciated,
thx,
avsrk Received on Tue Jun 03 2003 - 21:17:27 CEST