Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: new user & tablespace
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