> Good question. I can't think of any way to prevent a user from altering
> his own tables even if they can't create new ones. However, given the
> scenario you describe, why not create the countries table under an
> owner account, say for example, buck, which buck can then grant the
> required select/insert/update/delete privilages to sam?
Thanks. That's an option. A 3rd-party system that needs the data does not
recognize grants, snynonyms - it wants direct ownership. So we're
struggling through the issues. Grants/snynonyms will be supported in a
later version, thankfully.
Received on Wed Feb 16 2005 - 12:03:22 CST
