Case 1 Working Virtually with SQL Server
You are contracted by an application service provider to configure a VPD so that the company can arm support multiple customers with a single instance of an application. Using the ORDERS database, configure a VPD for the following users: acme_user, penco_user, and mfg_user. The solution should support all DML operations.
Case 2 Working Privately with Oracle
You were promoted to a project leader position at a software company that specializes in security pars application development. Your manager assigned you to design and develop a prototype (template) for a client. The client will use this prototype to implement the application. Your job is to provide this prototype according to these requirements:
- The application must use the following security access levels: 0 = none, 1 = select, 2 = update, 3 = delete
- A user should only see rows that are created by the user.
- A user with security access of level 6 can use SELECT, UPDATE, and DELETE functions (1+2+3), even if the row does not belong to the current user.
- Each row is assigned a security level.
- Each user is assigned a security level.