Re: Why doesn't GRANT RESOURCE quota qork ?

From: Michael P. Stein <>
Date: 13 Dec 1993 17:59:39 -0500
Message-ID: <2eis4r$>

Richard D Holowczak <> wrote:
>GRANT RESOURCE 5 M ON table_space TO user_name ;
>Why won't this work ?

    The HELP text in SQL*Plus is wrong. See the SQL Reference Manual. The quota must be in parentheses:

    GRANT RESOURCE (5 M) ON table_space TO user_name ;

In V7, this would be changed to:

    ALTER USER user_name QUOTA 5 M ON table_space ;

Mike Stein			The above represents the Absolute Truth.
POB 10420			Therefore it cannot possibly be the official
Arlington, VA  22210		position of my employer.
Received on Mon Dec 13 1993 - 23:59:39 CET

Original text of this message