Re: new user & tablespace

No, I agree.. the way you are doing it is fine. However, it requires you to remember to do something or else face the consequences. And since Oracle has recommended 'create session' followed by explicit quota grants since Oracle 8.0, I think that's the better way to go. If you forget the explicit quota grants, what's the worst that can happen? A 'create table' statement or similar fails... big deal. There's also an explicit comment somewhere (I forget where now) that connect and resource are only included in 8 and 8i for 'backwards compatibility' -and basically that's a warning that in some future version, they will cease to exist.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Yong Huang" <yong321_at_yahoo.com> wrote in message
news:b3cb12d6.0106101406.59e4947e_at_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.