Your course of action is correct. Sometimes, when giving advice, one tends to go down the road they think of first. In this case, I did suggest a stored procedure for implementing the solution. In hindsight, and with your suggestion, the QUOTA solution is a much more elegant solution.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.