Re: Why doesn't GRANT RESOURCE quota qork ?
Date: Tue, 14 Dec 1993 12:50:20 GMT
Message-ID: <1993Dec14.125020.25468_at_ornl.gov>
In article 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
I assume you're using Oracle7. 'GRANT RESOURCE' is expecting 'TO someone' or 'TO some_role'. Use 'ALTER USER', as in 'ALTER USER someone QUOTA 5M ON tablespace_name'.
Beverly Zygmunt
Oak Ridge National Lab
Received on Tue Dec 14 1993 - 13:50:20 CET