Re: create database link privilege error

Hi,

I got it to work. I was creating a public database link and i should have done GRANT CREATE PUBLIC DATABASE LINK to default_admin_role GRANT default_admin_role to SCHEMA_OWNER

select distinct(privilege) from role_sys_privs tells what privieleges are available

-thx,
avsrk

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0306040553.4c2c17e2_at_posting.google.com>...
> 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 - 22:54:47 CEST