Create a view as superuser

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 456,233 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,778 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser: Programming Forums

Thread Tools Display Modes

Views: 1285 | Replies: 1

•

Join Date: Nov 2007

Posts: 1

Reputation: clemente36 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

clemente36 clemente36 is offline

Offline

Newbie Poster

Create a view as superuser

Nov 7th, 2007

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