oracle

Please tell me I’m wrong

Go on. Please? I know noone likes to be shown they’re wrong. But being told you’ve got something wrong is great motivator to try and find out if you are. The quickest way to spur someone into really researching a subject than to point out a purported flaw in there knowlege. And it feels great when you find out you’re right, and even if you’re wrong, you know now the right answer.

This can be one of the best parts of a training course. Get 2 DBAs on a course (this is especially good if it’s a non Database course) and watch the sparks fly when there’s a difference of opinion on the wording of something. There’ll either be a great raging debate, or a lot of furtive googling while the instructor isn’t watching. Maybe even quoting of famous SQL bloggers or referring to obscure manufacturer briefing documents. Then at the next coffee break there’ll be a conversation about what was actually meant, arguments from experience, pleading that it was how the last version worked, arguing that it depends on OLTP vs OLAP/VLDB vs LBD/Sparc vs Itanium, makes difference if you’re on SAN rather than DAS, ad nauseum, ad infitum.

But the important thing is that one or more person is going to learn something, and that’s the most important thing. The minute you stop learning something you stop progressing as a DBA or IT professional, and you might as well resign yourself to doing the same thing for the next 30 years.

So please, tell me I’m wrong. Ill thank you for it in 20 years…………

 

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Stuart Moore

About Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

Granting developers truncate on Oracle tables

One of those occasional grants that you really wish you could grant. You have a large temporary table that the Devs are using for testing developments, but it’s not in a schema they control. They need to clean it down regularly, but you don’t want them blowing up loads of redo logging by using deletes. So letting them truncate the table sounds like the best idea.

Except in Oracle that’s a grant you can’t grant. As far as Oracle’s concerned truncating a table is the same as dropping a table. So you either need to grant the Developer ‘DROP ANY TABLE’ or ‘DBA’, neither of which are what you want to do as they grant them the ability to drop anything in the instance, or do even more damage.

So, the workaround? Well, create a stored procedure owned by the table owner which truncates the table, and grant

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Stuart Moore

About Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike