Thanks Frank - I appreciate the help here. To be sure I understand correctly before I run the sql statement:
My objective here is as follows. Currently the catalog has only two categories - private and retail. The vast majority of products are private with only a few retail products available to the public and should be available without logging in. All private products must be logged in to purchase or see prices.
Any non-logged in or logged in customer should be able to view retail products and buy retail products, but should not see the prices of the private products if they are not logged in (seeing the products is fine, just not the prices and not be able to add to cart). Any logged in customer should be able to see and purchase any product regardless of which category.
Am I on the right track with the customer privileges? It sounds like it, but just want to confirm first.