One way would be to create a view of that form and give them access to just the view. That way, you don't have to mess with the perms on the main DB tables.
Rick On Mon, Apr 14, 2008 at 11:12 AM, tricky maybe <[EMAIL PROTECTED]> wrote: > ** I have another $t#p|d question and please forgive me... How can I give > somebody access to just a specific table or view access to a table and just > for that table only using management studio? That user only needs to see > and be able to pull data on that table and should I give that user access to > the T111 table or just to the view of that? Our DBA is MIA so we don't have > one right now and I was kinda voluntered to do this stuff. > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *tricky maybe > *Sent:* Monday, April 14, 2008 11:02 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Difference between H and T table on SQL 2005 > > ** > Thanks Rick for clearing that out. I didn't really paid attention to the > data on the table and I was just looking at the number of rows. My mistake. > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Monday, April 14, 2008 10:46 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Difference between H and T table on SQL 2005 > > ** The H tables store Status History. As such, they've been around for a > VERY long time. Not all forms contain an H table, but all Regular forms do > - basically any form that contains the core field Status (Field ID 7). > > Rick > On Mon, Apr 14, 2008 at 10:37 AM, tricky maybe <[EMAIL PROTECTED]> > wrote: > ** > I'm just curious what the difference is between the T table and the H > table on SQL 2005. > I don't think the H table existed before we upgraded from SQL 2000. They > sure look the same for me but I'm not a SQL guy so I'm not sure why there's > an H table now. They both look the same with the same number of rows like > if I open table T111 it brings up 50 rows and if I bring up table H111 it > brings up the same records. We will have this table push to another SQL > server but I'm not sure which table to push. It is the H or the T table and > why? Please advise. Thanks > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
