Re: ?: Regarding privillage,Urgent

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Mon, 20 Nov 2000 10:12:49 -0500
Message-Id: <10686.122499@fatcity.com>

Thursday, November 16, 2000, 9:30:22 PM, Saroj Dash wrote:

DSCC> Can Every User by default can drop  and alter his /her own tables.
DSCC> Suppose i want to give only select ,insert,update privileges.How can I give
DSCC> ??

If you give a user the CREATE TABLE privilege, that user can create, alter, and drop his or her own tables. I just did a small test on this, and even if you revoke CREATE TABLE, the user can still drop his own tables.

Best regards,

Jonathan
mailto:jonathan_at_gennick.com
http://gennick.com Received on Mon Nov 20 2000 - 09:12:49 CST