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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
