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: new user & tablespace

Re: new user & tablespace

From: Yong Huang <yong321_at_yahoo.com>
Date: 10 Jun 2001 15:06:57 -0700
Message-ID: <b3cb12d6.0106101406.59e4947e@posting.google.com>

I often grant connect, resource to fred followed by revoke unlimited tablespace from fred. I specify quota when I create user or afterwards with alter user. I also often grant select_catalog_role to any user I create. I think my users deserve to know more unless you don't want to learn Oracle.

Yong Huang
yong321_at_yahoo.com

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:<3b1f3dcf_at_news.iprimus.com.au>...
> Incidentally, I see that some are recommending granting 'resource to fred'.
> Don't. In Oracle 7, you'd usually create a user and then 'grant connect,
> resource to fred'. Trouble is, resource implies unlimited quota on
> everything.
Received on Sun Jun 10 2001 - 17:06:57 CDT

Original text of this message

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