March 4, 2004 at 1:56 pm
I have a problem that seems to be a bug in SQL Server. We have a database that is in merge replication with 5 subscribers. The platform is SQL Server 2000 SP3a running on Windows 2000 Server SP4.
The problem occurs in tables where fields are added through the publication. We added a field by going to the publication properties -> Filter Columns -> select appropriate table -> click Add Column to Table. This is done with replication up & running. The field is created and pushed to subscribers with no problem.
The problem occurs when I try to set the permissions for the newly added field. I have been unable to control the permissions on the column either through the management console or via the GRANT command in the query analyzer. In addition, I backed up and restored the production database onto test server with no replication. I was still unabble to control permissions on the column added through the publication. Also, I added another field manually to the affected table and was unable to control permissions on that column either. I went to another table in the same database and was able to add fields and control permissions at will. The only problems were encountered with tables where fields had been added through the publication.
Does anyone have a clue? I have a user in one of the subscriber locations that needs update access to the new column.
I Only Work Here......
March 4, 2004 at 9:00 pm
March 5, 2004 at 2:33 am
No error. Everything appears to execute normally. However, when I re-enter the Manage Permissions interface, the permissions I assigned to the added columns are not there. In several tests, I would change the permissions on a several columns at the same time. Some of the columns had been added while others were original columns. When I re-entered the Manage Permissions interface, only the permissions I assigned to the original columns had remained. An attempt to make an update to the table verified that the permissins were not set for the added columns.
I attempted to change the permissions as described above by two different methods: one was through the Manage Permissions interface in the MMC, the other was with a GRANT command in Query Analyzer. Same result either way.
I'm stumped.
I Only Work Here......
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply