Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Revoke Create and Alter Table

Re: Revoke Create and Alter Table

From: Arun Mathur <themathurs_at_gmail.com>
Date: 16 Feb 2005 08:18:10 -0800
Message-ID: <1108570690.183421.58940@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US