My table has got product levels and each product would be connected with the root thru other nodes.
when i want to give permissions to access only one level of product to the user. How can i achieve that.
for example level1 may be brand and level2 can be color and level3 be the final product for one product
next product may start with type as level1 then brand then size then colour then material then final product.
like this the levels can be anything for any product. it goes till 20 also for some products. and the number of products also in thousands.
How the table should be structed to get the best performance in a DataWarehouse environment.