Re: How to grant create owner table?
Date: Thu, 10 Nov 1994 07:59:01 GMT
Message-ID: <ALVINLAW.94Nov9235901_at_netcom11.netcom.com>
In article <39ruoq$e19_at_news1.shell> sjs_at_shell.portal.com (Steve - Schow) writes:
> Anyone know how to grant to user A the ability to create and drop tables
> owned by user B?
Another RTFM type answers...
Oracle7(tm) Server Administrator's Guide, p.8-23,
"... To create a table in another user's schema, you must have the
CREATE ANY TABLE system privilege. Additionally, the owner of the
table must have a quota for the tablespace that contains the table,
or the UNLIMITED TABLESPACE system privilege."
Oracle7(tm) Server Administrator's Guide, p.8-25,
"... To drop a table, the table must be contained in your schema or
you must have the DROP ANY TABLE system privilege to drop the table."
--
"And this is all I have to say about that..."
`o<'
---------------------------------oo0(__)0oo--------------------------------
__ __ __ __ __ _ _ __ U __ _ __ _
/__\ ( )( )( )( )( \( ) ( ) /__\( ( ) ) "You may be an idoit,
/(__)\ )(__\ () / )( ) ( )(__ /(__)\\ / / but try not to be
(__)(__)(____)\__/ (__)(_)\_) (____)(__)(__)\/\/ stupid." - F. Gump
Received on Thu Nov 10 1994 - 08:59:01 CET