Re: Database Administrators - help please!
From: JEFF CHAMBLEE <chamblej_at_author.gsfc.nasa.gov>
Date: 8 Jul 1993 10:15 -0500
Message-ID: <8JUL199310151276_at_author.gsfc.nasa.gov>
Date: 8 Jul 1993 10:15 -0500
Message-ID: <8JUL199310151276_at_author.gsfc.nasa.gov>
In article <1993Jul8.140046.1_at_geovax.ed.ac.uk>, msc9342_at_geovax.ed.ac.uk writes...
>
>Granting extra resource privileges
>----------------------------------
>
>I accept that this is a rather specialised question
>but any help would be extremely appreciated:
>
>The problem is that my resource privilege or space quota
>is insufficient for adding new tables to my ORACLE account.
My V6.0 DBA course guide says:
1. Logon to SQLPLUS or SQLDBA as SYS or some DBA account 2. GRANT RESOURCE(bytes) ON tablespace TO user; 3. Verify with SELECT * FROM sys.dba_ts_quotas;
Hope that helps.
Jeff Chamblee Received on Thu Jul 08 1993 - 17:15:10 CEST