we have two databases in production and developers are writing a code/porcedure to querry and update some tables
in second database defenetly through DBlink.Im just worried about this bcoz updating a diff database--is there any security issues
i can look forward to make this procedure more reliable.Thanks
we are using 8.1.5 on solaris 2.6 on both the servers.
but the probelm will be if I use a private dblink then the whole db will be opened for that user thro the procedure.and i think i cant give a password to that bcause this procedure will be excuted thro application code.Can i give some privilages i mean select ,insert and update to Dblink.is it possible.
See the syntax in this posting and give the user whatever the privileges you want ot give for "xxxwebt". No big deal your problem will be solved. Thats what I do whenever I create db link. I never create public link unless its necessary.