In a SQL 2k instance (latest SP) some of my user databases show the public role with execute on a variety of stored procs named dt_* (i.e. dt_addtosourcecontrol). However, not all the user databases do this, some do not grant the public role execute on these procs .
So, can someone explain what generates these permissions and is it acceptable to remove them? If I have a database that does not grant public access, should I be concerned? I don't see any reference to these procs in BOL.
TIA,
Moblex
This seems to be a Visual Studio generated procedure, so you should ask this question on a Visual Studio forum. Here's a related thread
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=562892&SiteID=17
that I found with the following search query:
http://search.live.com/results.aspx?q=dt_addtosourcecontrol&mkt=en-us&FORM=LVSP&go.x=10&go.y=13
Thanks
Laurentiu
No comments:
Post a Comment