DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: secured database--urgent pls

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    Angry

    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.
    sat

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.


  3. #3
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    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.
    sat

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=6584[/url]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width