RE: CREATE DATABASE LINK privilege discussion

Hi Chris, Alan,

> 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@xxxxxxxxx [mailto:alanbort@xxxxxxxxx] On Behalf Of Guillermo 
>> Alan Bort
>> Sent: Monday, October 31, 2011 2:41 PM
>> To: Taylor, Chris David
>> Cc: Joel.Patterson@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>> 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

Other related posts: