Member Avatar for clemente36

create a view as superuser

create view V_CUSTOMERS based on Customers Table and give an access to enter, select records to Appuse01,Appuser02,Appuser) and Appuser04 for all the columns excepting Price and Total_val. These two columns will be update by procedure. They should be able to see their records only and not other user's records for security reasons.

Columns:
S_NO
CTL_UPD_User
Cust_Name
DT
Item_id
Item_Name
Quantity
Payment_type
Price
Total_Val

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by fatihpiristine
Member Avatar for fatihpiristine

create view which select only those columns .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.