index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: Can you restrict access to records in a table :: (4) Post a New Message | Post a Reply
Feb 25 2005, 7:12 PM	Can you restrict access to records in a table Post a Reply
blocka since: Feb 25, 2005 from: Ontario	I'm wondering if there is a way to restrict a user to specific records in a table -- for example, we want them to only see records that belong to them (via their userid for example).
Feb 25 2005, 8:13 PM	Re: Can you restrict access to records in a table Post a Reply
ghost from: Washington, DC	You can do that thru the use of several properties of the report wizard including HiddenTables, HiddenReports, UseTables etc. Check out the tutorials below and let me know if that helps. 1. Hiding Tables, Views, Reports & Fields 2. Managing the Report Wizard's User-Rights ------------------------- Ghost
Feb 26 2005, 5:06 AM	Re: Can you restrict access to records in a table Post a Reply
blocka since: Feb 25, 2005 from: Ontario	I see that perhaps with UseProcedures I could pass a userid to a set of stored procedures (or views??) that would filter by user id, but that means they couldn't query tables (which perhaps is required). Basically, I have a data table with a column UserID, and I only want the user to be able to see records where their session UserID is the same as that in the data table...
Feb 28 2005, 5:33 AM	Re: Can you restrict access to records in a table Post a Reply
ghost from: Washington, DC	Check the following tutorial: Adding Report Parameters ------------------------- Ghost
Pages: (1)   [1]

search this forum: