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