Re: create database link privilege error

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<25c1993e.0306031117.1474d1ff_at_posting.google.com>...
> 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

The following is taken directly from the Oracle 9i SQL maual: Restriction: You cannot create a database link in another user's schema, and you cannot qualify dblink with the name of a schema.

HTH -- Mark D Powell -- Received on Wed Jun 04 2003 - 15:53:40 CEST