Re: create table/index priviledge

In article <8vva5d$tmq$1_at_nnrp1.deja.com>,   gzwzhang_at_my-deja.com wrote:
> HOw to revoke 'create table' and 'create index' priviledge from a
 user?
> That user can own the tables, indexes, but those table/indexes must be
> created by DBA for him.
>
> Any idea will be appreciated?

Hi,
If the user owns the tables, hi will always be able to drop them. I would suggest creating the tables by the dba, granting select, update or delete from these tables to a role, and grantig the role to the user.

Check out that the user does not have the ressource role granted, since this role has the create any table sys privilege.

HTH

--
-=[ Sancho ]=-


Sent via Deja.com http://www.deja.com/
Before you buy.