Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Product Levels Expand / Collapse
Author
Message
Posted Wednesday, September 10, 2008 2:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:11 AM
Points: 317, Visits: 929
Hi,

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.

thanks,
Regards
Viji
Post #566665
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse