Re: Why doesn't GRANT RESOURCE quota qork ?

noel_at_omega.univ-lille1.fr (Yves Noel) writes:

>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 ?
>|>
>My suggestion is that there's NO SPACE between 5 and M --> 5M
>--

   OK OK OK! I got it now. Thanks to about 1000 responses!

   For Oracle 7, use ALTER USER.

   For Oracle 6, the syntax for the on-line help is    not correct. The proper syntax should be :

        GRANT RESOURCE (5M) ON tablespace TO username ;

    Seems the on-line help omitted the parenthases around     the quota of 5 megabytes in this case.

     The space/no-space thing is irrelavent.

Many thanks to all who responded.

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu Received on Tue Dec 14 1993 - 20:01:38 CET