If you have a schema where you want developers to have read-only access to all tables, but you don’t want to grant select any, keeping up with new tables can be a challenge. We wrap the following into a script that runs a few times a day. We have a DBA schema in each database [...]
Archive for January, 2010
Maintain role permissions on new objects
Posted in Access / Users, tagged trigger role on January 28, 2010 | Leave a Comment »
Estimating Flashback retention size (FRA)
Posted in Flashback, tagged estimate, Flashback, FRA, oracle on January 21, 2010 | 1 Comment »
Early last year there was a dearth of information out there about estimating FRA before turning it on on an existing production database (not a new one). Since then, lots of advice has appeared online. Since we haven’t implemented Flashback yet on any database, we need to analyze how much additional space would be necessary, [...]
Striking out from the bank …
Posted in General on January 21, 2010 | Leave a Comment »
In 2008, after a few years in support, eight years as a programmer, and four years as an IT manager, I wanted a change and moved into an Oracle DBA role. I hoped to chronicle the experience and tracks bits of flotsam that helped me along the way, but the first year was such a [...]
