Last post Jul 20, 2005 04:47 PM by AerosSaga
Jul 19, 2005 08:02 PM|aspgator|LINK
Is there a module out there that will allow my different users to access certain tables and views within these tables. For example user1 logons and is able to see a products table but unable to see the associated costs on the table.
Jul 19, 2005 08:38 PM|PScarlett|LINK
SQLGridSelectedView is capable of passing the UserID string into a predefined select statement. Thus, you could create a select that only displays the certain column data if the UserID matches a given criteria. You could use the CASE command to display
the value when a match exists or blank if not.
This is a rather limited way to provide what you are after, but if it is just a specific case it maybe enuf. [;)]
SQLGridSelectedView is available at http://www.tz3p9v.ca for free - just register and download.
Hope this helps
Jul 20, 2005 12:48 PM|aspgator|LINK
Jul 20, 2005 04:47 PM|AerosSaga|LINK