如何设置权限 [英] how to set permission

问题描述

我想隐藏一个公司出售给另一公司的产品的价格和详细信息.我有2家公司要出售其产品.为了增加产品，我有一张桌子，有关产品的详细信息，我还有一张桌子.我希望两家公司都看不到他们出售哪些产品以及以什么价格出售.请回答我该怎么做.我在产品表中有companyid.

I want to hide the prices and details of the product sold by one company to another company . I have 2 companies whose product i am selling . And for adding there products i have a table and for details of products i have another table . I want that both companies did not see that which products they sale and at what price they sell . please reply how can i do that. I have companyid in product table.

推荐答案

您应该有某种company列.将其用于
中的条件

You should have a company column of some sort. Use that in the criteria as in

SELECT * FROM mytable WHERE companyname = 'Company 1'

请注意，请勿将*用作列的列表.

Note do not use * as your list of columns.

这篇关于如何设置权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！