Understanding a database view in SAP HANA database

SAP HANASAPSAP Basis

Consider the following example −

Example

            Id            
Empl. Name
Empl.user
Empl.password
Joining Date
1
 Employee 1
  Emp1
Emp1Pwd      
9/11/2016
2
 Employee 2
Emp2
Emp2Pwd
16/08/2015
3
Employee 3
 Emp3
Emp3Pwd  
15/09/2016
4
Employee 4
Emp4  
Emp4Pwd
3/07/2014
5
Employee 5
  Emp5    
Emp5Pwd
 10/09/2012
6
 Employee 6
Emp6  
Emp6Pwd  
1/10/2013

         

Consider a scenario when a developer needs to analyze some data of Employee Table with the above fields. Using database view, an administrator can create a virtual table which only contains information about Employee Id, Employee name, and date of joining and give permission to developer to use that view.

raja
Published on 21-Feb-2018 19:40:32
Advertisements