I'll let those more practiced in the process describe it. I've done it once, and I'm not on a SQL system at the moment to be able to walk through it. Basically, you would create a view of the table in question, and then modify the permissions on the view to allow access to it.
I would NOT change any of the permissions on the table itself - only the view of it. Rick On Mon, Apr 14, 2008 at 11:32 AM, tricky maybe <[EMAIL PROTECTED]> wrote: > ** Do I just right click on the view then give the user access? When I > did that and I tested to login as that user I was able to view all other > tables and views on the database. How can I make it so that the user will > only have permission to that single table or view? > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Monday, April 14, 2008 11:23 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Difference between H and T table on SQL 2005 > > ** 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___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
