Re: Why doesn't GRANT RESOURCE quota qork ?
From: Michael P. Stein <mstein_at_access3.digex.net>
Date: 13 Dec 1993 17:59:39 -0500
Message-ID: <2eis4r$a22_at_access3.digex.net>
Date: 13 Dec 1993 17:59:39 -0500
Message-ID: <2eis4r$a22_at_access3.digex.net>
Richard D Holowczak <holowcza_at_andromeda.rutgers.edu> 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