Hi,
I'm using SQL server 2000. I have set advanced security on and have created two users SYS-CONFIG and ADMIN.
The problem is that I do not see any menu items, even though the user is authorised for the table. I did some search and found the error in the code.
if InArray("tblRegion") then
Response.Write "<a href=""tblRegion_list.asp"">dbo.tblRegion</a> <br>"
end if
if InArray("tblSMUPriceListMapping") then
Response.Write "<a href=""tblSMUPriceListMapping_list.asp"">dbo.tblSMUPriceListMapping</a> <br>"
end if
Sub GetTables(sUserName)
Select Case sUserName
Case "SYS-CONFIG"
arr = Array("dbo.tblPlant", "dbo.tblPlantMapping", "dbo.tblPriceBoundary", "dbo.tblPriceList")
Case "ADMIN"
arr = Array("dbo.tblPlant", "dbo.tblPlantMapping", "dbo.tblPriceBoundary", "dbo.tblRegion")
....
In the array the tables are preceded by "dbo." However when the check is doen it uses the table name without dbo.
Is this caused because we are doing something wrong or is it a bug?
Thanks again
Joost
