Re: How to grant create owner table?

From: Alvin Law <alvinlaw_at_netcom.com>
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

Original text of this message