Hi all,
I'm currently having a problem which I donno what to do, pls help....
here is the problem:
2 sql server 7.0 runing merge replication, but what we wanted to do is build some blocking for the subscriber for reading the data, the data contains 2 type, let say type A and type B, what we want is for publisher, they can do read & write access for both type (A & B), but for its subscriber, they can only read type A, but got read and write access for type B. I did think of using view to block some of the access, but the problem is there is a third party program which I can't change and the program is coded to read data from its table (fixed table name), and the data is for all tables, so for subscriber, they can read all type A data on all tables and read & write access for type B data on all tables. I'm not sure is there a way in sql server 7 to block the data in row level and how.
pls help.
Thanx,
Westley
I'm currently having a problem which I donno what to do, pls help....
here is the problem:
2 sql server 7.0 runing merge replication, but what we wanted to do is build some blocking for the subscriber for reading the data, the data contains 2 type, let say type A and type B, what we want is for publisher, they can do read & write access for both type (A & B), but for its subscriber, they can only read type A, but got read and write access for type B. I did think of using view to block some of the access, but the problem is there is a third party program which I can't change and the program is coded to read data from its table (fixed table name), and the data is for all tables, so for subscriber, they can read all type A data on all tables and read & write access for type B data on all tables. I'm not sure is there a way in sql server 7 to block the data in row level and how.
pls help.
Thanx,
Westley