Re: Why doesn't GRANT RESOURCE quota qork ?

Richard D Holowczak (holowcza_at_andromeda.rutgers.edu) wrote:
: 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

I am on 7 so the synatax has changed but I think you have to slide that "M" right up to that 5..

Good-luck

--
Shawn Belaire
Geodetic Survey of Canada
Ottawa, Ontario, Canada
Internet: belaire_at_geod.emr.ca