Gating Role

Its Granting Role and not Gatting Role..
More info about how to Grant Role here

http://msdn.microsoft.com/en-us/library/ms173848.aspx

I am talking about the gating role which is mentioned in the topic: http://msdn.microsoft.com/en-us/library/cc645961.aspx

to control and make easy to access to the Change Data Capture resources on the sql server roles are used. Permissions defined over the role and users assigned to the role. Otherwise users should have given the select permission on the columns that are captured. For this reason the roles are called as gating role...

Was it a typo by Microsoft?

tigin44: The roles are used for the same reason in other contexts also. Is it called gating role only in the context of CDC (Change Data Capture) or in all the cases?

>> To gain access to the change data that is associated with a capture instance, the user must be granted select access to all the captured columns of the associated source table. In addition, if a gating role is specified when the capture instance is created, the caller must also be a member of the specified gating role. Other general change data capture functions for accessing metadata will be accessible to all database users through the public role, although access to the returned metadata will also typically be gated by using select access to the underlying source tables, and by membership in any defined gating roles.

If you see the context in the link provided, its more or less equivalent to GRANT SELECT statement on the tables involved.

I was checking the new features of SQL2008 in BOL and was about to read the article given by DCMBS. Now I got the answer I want. Thank you.