Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1226
  • Last Modified:

Gating Role

Can someone please tell me what a Gating Role is in the context of SQL Server?
0
Srinivas_Vengala
Asked:
Srinivas_Vengala
  • 4
  • 2
  • 2
  • +1
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Its Granting Role and not Gatting Role..
More info about how to Grant Role here

http://msdn.microsoft.com/en-us/library/ms173848.aspx
0
 
Srinivas_VengalaAuthor Commented:
I am talking about the gating role which is mentioned in the topic: http://msdn.microsoft.com/en-us/library/cc645961.aspx
0
 
tigin44Commented:
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...
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Srinivas_VengalaAuthor Commented:
Was it a typo by Microsoft?
0
 
Srinivas_VengalaAuthor Commented:
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?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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.
0
 
DCMBSCommented:
The gating role is explained here

http://technet.microsoft.com/en-us/library/cc627369.aspx

Scrool down to A role for controlling access to a change table.
0
 
tigin44Commented:
the terminology introduced by the change data capture... but the other database and application roles also do behave same...
0
 
Srinivas_VengalaAuthor Commented:
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.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now