RE: CREATE DATABASE LINK privilege discussion

> I effectively slapped him with a large trout when I told him he was acting like my 14 year old...

lol ! I really love this « large trout » approach. Thanks guys :)

Chris, as Alan wrote, this new project has Oracle Streams written all over it. Or Golden Gate if you have licenses for it.

> after he criticized me through IM because he *assumed* I removed his privs, when in fact he missed a grant -
> I also felt the need to point out to him the reason his process broke was because he failed to identify the grants he needed.
> Needless to say, that has *not* helped the situation.

Why am I not surprised? :)

> Funny thing is, I've already mentioned replicating the data into both DEV & PROD so he has access to it.
> (We have a dev db that gets rebuilt from prod every weekend).
> That way the data would always exist in prod and he would always have access to it in the refreshed dev instance.
> Of course, that suggestion hasn't gotten any traction.

Humm, then you next move is probably a political one. Because this IS the best approach for everyone. But then, who ever said comon sense prevailed?

Good luck,

David

> Chris Taylor
> Sr. Oracle DBA
> Ingram Barge Company
> Nashville, TN 37205
>
>> From: alanbort_at_gmail.com [mailto:alanbort_at_gmail.com] On Behalf Of Guillermo Alan Bort
>> Sent: Monday, October 31, 2011 2:41 PM
>> To: Taylor, Chris David
>> Cc: Joel.Patterson_at_crowley.com; oracle-l_at_freelists.org
>> Subject: Re: CREATE DATABASE LINK privilege discussion
>>
>> Just a crazy thought, but if he ABSOLUTELY NEEDS THE DATA, you can set up some from of replication (if it's a single table AQ or Streams could work, GG if you have the license) and let him work off a replica of the data. Probably he needs a subset of tables and not the entire prod database. That way you remove the need for him to use db links, you come out as "solution oriented" and you get those dirty, dirty DB links off your prod database.
>>
>> That, or slap the developer with a large trout... your call.
>>
>> Cheers and HTH
>> Alan.-

--
http://www.freelists.org/webpage/oracle-l