Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Secure Views

Oracle has supported database views for many years. Views can be used to solve many challenges, and views can be a tremendous security tool. Views can hide columns. Views can mask data values. Views can aggregate data to remove personally identifiable information for maintaining privacy. The part I like best is that the view is not redundant or duplicated data; it is nothing more than stored SQL.

An effective security design usually involves the judicious use of views for any or all of the reasons just cited. Views are database objects and access to them occurs at the object level. However, privileges on the view are separate and distinct from the privileges on the underlying objects the view accesses. Allowing users access to a view and not to the underlying objects is an effective security technique for insulating your sensitive data.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint