Re: new user & tablespace

Howard J. Rogers wrote in news:3b1f3dcf_at_news.iprimus.com.au on 07 Jun 2001:

> 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.

Actually you can do "better" than that with the syntax

grant connect, resource to fred identified by flintstone;

which will also create the user if it doesn't exist. Sometime soon Oracle will see sense and stop this nonsense from working.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK