CODEWITHSUNDEEP
sql-server
bjnr
bjnr

Reputation: 3437

Prevent table updating

I have more tables replicated using transactional replication with push subscription. How can I prevent users/stored procedures updating those tables?

Upvotes: 0

Views: 61

Answers (1)

jean
jean

Reputation: 4350

Create a user without rights to run that SP or write in that tables and use it as the user for your needs (run app, etc).

Upvotes: 1

Related Questions