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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: 10 Jun 2001 18:01:42 GMT
Message-ID: <Xns90BCC22D9FFCDsaLKSAaaslw1245133@195.129.110.131>

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
Received on Sun Jun 10 2001 - 13:01:42 CDT

Original text of this message

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