Re: Why doesn't GRANT RESOURCE quota qork ?

From: Yves Noel <noel_at_omega.univ-lille1.fr>
Date: 14 Dec 1993 09:33:54 GMT
Message-ID: <2ek1a2$muu_at_netserver.univ-lille1.fr>


In article <Dec.13.15.06.08.1993.29033_at_andromeda.rutgers.edu>, holowcza_at_andromeda.rutgers.edu (Richard D Holowczak) writes:
|>Hi folks. I'm trying to limit the resources
|>my users take up by using the GRANT command.
|>
|>The synatx looks like:
|>
|>GRANT RESOURCE 5 M ON table_space TO user_name ;
|>
|>
|>Why won't this work ?
|>
|>Oracle gives me an error pointing to the '5'
|>saying: 'Missing TO keyword'.
|>
|>Any suggestions ?
|>
|>THanks
|>
|>Rich Holowczak
|>Rutgers University
|>holowcza_at_andromeda.rutgers.edu
|>
 My suggestion is that there's NO SPACE between 5 and M --> 5M

-- 
------------------------------------------------------------------------------
   _/_/_/_/    _/_/_/_/   _/_/_/_/   _/_/_/_/                  I use
  _/_/          _/_/       _/_/       _/_/               ORACLE v6.0.36.5.2
 _/_/          _/_/       _/_/       _/_/                       on        
_/_/_/_/ .  _/_/_/_/ .   _/_/ .   _/_/_/_/ .            DEC RISC ULTRIX v4.3
------------------------------------------------------------------------------
Yves NOEL   -   Database Administrator         Mail : Yves.Noel_at_univ-lille1.fr
C.I.T.I. (batiment M4)                             
Universite des Sciences & Technologies de Lille      Phone : (33)  20.43.42.70
59655 Villeneuve d'Ascq Cedex - FRANCE               Fax   : (33)  20.43.66.25 
------------------------------------------------------------------------------
Received on Tue Dec 14 1993 - 10:33:54 CET

Original text of this message