Printable View
Folks
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.
Use Private and secured dblink with password rather public link if you are concerned with security for DML activity of your data. Its helpful if you elaborate situation with more details.
sreddy thx..
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.
http://www.dbasupport.com/forums/sho...?threadid=6584