Implementing DB2 views

When you design your database, you might need to give users access to only certain pieces of data. You can give users access by designing and using views.

You can use views to perform the following tasks:

• Control access to a table
• Make data easier to use
• Simplify authorization by granting access to a view without granting access to the table
• Show only portions of data in the table
• Show summary data for a given table
• Combine two or more tables in meaningful ways