AUTHID_CURRENT_USER can be misused by developers. The new object privilege INHERIT PRIVILEGES ON <USER> was introduced in 12c to prevent that. I start with a demo to explain the problem that the new features solves. The playground:
It is no secret that we are generating increasing amounts of data every day. Hundreds of apps on our phones that we carry with us every day, amass a collection of data from connected devices. Hundreds and thousands of different computer systems enable the operations of every single company in the planet. We are at the point where we generate more data than we sometimes know what to do with. Previously, organizations would, at best, case archive it, and worst case, simply delete it and carry on.
As part of an ongoing Exadata migration assignment, we have been exploring Oracle 12c multitenant capabilities a lot. I would like to share here some of selected useful MOS Doc about 12c multitenant concepts:
Below docs explains most of the 12c multitenant concepts:
Oracle made a great announcement this past June that had me and many other people excited. Oracle has long made advances in the engineered systems space. In fact, in April 2016, the new X6 Exadata machines were announced. I have two friends who work as DBAs at organizations that have Exadatas. They tell me how easy they are to…