UAUptime Architectinuptimearchitect.hashnode.dev·15h ago · 13 min readOracle Privilege Analysis: You Granted DBA. Here's What They Actually Used.Someone needed to read one table. The ticket said "just give the app the standard role so we can ship," the role already carried half a dozen ANY privileges, and it got granted. Three years later that00
UAUptime Architectinuptimearchitect.hashnode.dev·3d ago · 15 min readOracle Virtual Private Database: Row-Level Security You Can't Route AroundYou wrote a view that filters each sales rep to their own region, granted the view, revoked the table, and called it row-level security. It worked — until the reporting team needed the base table, or 00
UAUptime Architectinuptimearchitect.hashnode.dev·6d ago · 13 min readOracle Data Pump, Done Right: A Migration You Can Proveexpdp full=y and hope is not a migration plan. It's how you find out at 3 a.m. that the dump ran out of space, or the import invented a half-populated schema, or the "quick refresh" locked the source 00
UAUptime Architectinuptimearchitect.hashnode.dev·Sep 9 · 13 min readOracle Partition Pruning: Read One Partition, Not the Whole TableSomeone partitions the big table, the migration ticket gets closed, and everyone moves on believing the queries are now fast. Then a report that should read one month of data reads all of it, the plan00
UAUptime Architectinuptimearchitect.hashnode.dev·Sep 7 · 17 min readOracle Data Redaction: Mask at Read Time, Prove It Isn't Access ControlThe support rep sees ****-****-****-0001 on their screen and everyone relaxes. The card number is "masked," the demo looks compliant, the box gets ticked. Then someone runs an export, or a report buil00