Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Product Levels Expand / Collapse
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, March 11, 2016 4:23 AM
Points: 336, Visits: 1,026

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.

Post #566665
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse