In the previous two parts of this article on implementing security in an environment of “Oracle Exadata Database Machine” it has shown the way in which security is created at the level of ASM (Part 1) and database level (Part 2) to meet the different requirements of the organization and accompany the entire lifecycle of the data. In the latter part of the article it will demonstrate how to remove security settings at both ASM and in terms of database, so not only the article in its three parts will help implement security in your organization but also to demonstrate the procedure of removing the security it provides a comprehensive article that can be used for testing purposes or for educational purposes. “Oracle Exadata Database Machine” every day is gaining popularity in the countries of Latin America, not only by low times used to process large amounts of data, compression cup provides “Hybrid Columnar Compression”, but because it provides many features facilitating the administration of database servers and storage, however, as there are many servers (22 servers in a “Full Rack”, and taking into account that “Oracle Exadata Database Machine is a scalable solution”) security is an emerging problem that can be compared with the security problem when a database the number of users is large. It is known that for managing user privileges easier there are roles, which is nothing more than a group of users, well, safety Exadata would become an analogy, where roles might be clusters of ASM and Users might be the databases, you can restrict access to the “Grid Disk” gathering the databases by using a single cluster of ASM (Coarse granularity) or you can restrict access to the “Grid Disk” by each of the databases (fine granularity).
Oracle Exadata Database Machine : ASM Level Security and Data Base ( Part 3 )
About the Author: yvravikumar
Ravikumar has nearly two decades of experience in the industry and has spent most of his career in architecting, designing, implementing and maintaining enterprise and world class database solutions. He is a well known Oracle technology expert and is an Oracle Certified Master (OCM) & Oracle ACE. His in-depth knowledge and hands on experience in Databases, Operating systems and enterprise applications has helped leading organizations successfully implement and run efficient and well-designed data centric technology. He continuously trains, mentors and motivates budding DBA’s. He is an expert trainer and a consultant on latest database technologies. He is a co-founder of OraWorld and is a regular speaker at OTN Yathra and an active member of AIOUG. For More Details: Oracle ACE Oracle Certified Master (OCM) Co-Founder Of Oraworld-team