Retrieve serial numbers and other useful information from Exadata

It’s been a while since my last post!
Today, I wanted to share with you some useful commands to extract information from Exadata (product name, serial numbers, …).
This can be helpful for the opening of an new SR for example, or for inventorying components in a CMDB.

Here is the list of interesting elements that can be extracted (the list is not exhaustive, but these are the ones I use most often):

Exadata product name
Exadata rack serial number
Compute nodes and cell nodes serial number
Compute nodes and cell nodes internal component’s serial number
Inifiniband switches serial number
Cisco switch serial number
PDU’s serial number

Continue reading “Retrieve serial numbers and other useful information from Exadata”

Hide table content to users with “SELECT ANY TABLE” privilege

Today, we will see how to hide sensitive data in your Oracle database from other users with the “SELECT ANY TABLE” privilege using Oracle Virtual Private Database (VPD).

First of all: in a perfect world, this situation should never happen!
If you need to store sensitive data in your database, you should place it in a dedicated location, without any other schema and with strict security rules.

Anyway, if you choose to tread this post, you probably have no other choice.

Continue reading “Hide table content to users with “SELECT ANY TABLE” privilege”