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

Thread: distributed database

  1. #1
    Join Date
    Jul 2001
    Posts
    1
    Hello
    We have two databases A and B
    There is a application which access db B
    All application users have access to db B through sql (cannot block users from sql).
    Data changed/inserted in B should come to A
    May be we can create db link and synonyms.
    How to implement this any suggestions please

    Main idea is to prevent the data modification through sql prompt. and db A is setup with regular backups, so data will be backed up.

    thanks in advance

  2. #2
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    What is it you want exactly?
    You can prevent users from accessing tables by reveoking their priveileges on the tables.

    Inserts can also be prevented using Before insert/update triggers...
    Hemant

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    If you are dealing with two clone databases, set one up as hot standby in read only mode. Users can read the data there, say on server B. All update activity takes place on server A.

    Between role and object privileges and hot standby, changes can be minimized.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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