Re: insert privilege across db link

in the db link are you using the same user as the table owner in the remote db. in your case are you using the user "b" in your dblink?

babu
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 03, 2002 3:35 PM

> database is 8.1.7
>
> how do I grant insert privilege to a user in a different database?
>
> Note: the database link in place in both database and I can describe
tables in each just fine. In the trigger I already have the insert into b.address_at_bschema. When I try to execute the
> trigger I get insufficient privileges. I have tried the trigger locally
and it works just fine it is when I try to insert a row across the database link I get insufficient privileges.
>
>
> What am I missing/forgetting?
>
> Thanks
>
> Kathy
>
>
>
> Confidential
> This e-mail and any files transmitted with it are the property
> of Belkin Components and/or its affiliates, are confidential,
> and are intended solely for the use of the individual or
> entity to whom this e-mail is addressed. If you are not one
> of the named recipients or otherwise have reason to believe
> that you have received this e-mail in error, please notify the
> sender and delete this message immediately from your computer.
> Any other use, retention, dissemination, forwarding, printing
> or copying of this e-mail is strictly prohibited.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kathy Duret
> INET: KathyD_at_belkin.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babu Nagarajan
  INET: orclbabu_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).