Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Revoke Create and Alter Table
Hi Buck,
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?
Regards,
Arun
Received on Wed Feb 16 2005 - 10:18:10 CST