VIEW CHANGE TRACKING is a permission provided by sql server.

Grant VIEW CHANGE TRACKING permission on a table to a user:
[sql]
GRANT VIEW CHANGE TRACKING ON OBJECT::dbo.databaselog to username
[/sql]

Revoke VIEW CHANGE TRACKING permission on a table to a user:
[sql]
Revoke VIEW CHANGE TRACKING ON OBJECT::dbo.databaselog to username
[/sql]

DENY VIEVIEW CHANGE TRACKING permission on a table to a user:
[sql]
DENY VIEW CHANGE TRACKING ON OBJECT::dbo.databaselog to aaaaaa
[/sql]

Leave a Reply

Your email address will not be published. Required fields are marked *