Re: Can I remove a table from the recycle bin?

From: Thomas Kellerer <JUAXQOSZFGQQ_at_spammotel.com>
Date: Mon, 09 Apr 2007 12:11:02 +0200
Message-ID: <57uhplF2eaps7U1@mid.individual.net>

sybrandb_at_hccnet.nl wrote on 09.04.2007 12:00:
> On 8 Apr 2007 17:43:35 -0700, "Mark D Powell" <Mark.Powell_at_eds.com>
> wrote:
>

>> Mladen is right, developers should not have the authority to issue
>> ALTER SYSTEM commands.  ALTER SESSION maybe, but definitely not ALTER
>> SYSTEM.
>>
>> IMHO -- Mark D Powell --

>
> Are you aware how many third party developers require CONNECT,
> RESOURCE and DBA privileges for their software?
> Are you aware that there is a developer called Oracle, which also
> requires those privileges (and doesn't protect any account with a
> proper password).
>
> Do you know of any third party developer NOT requiring those
> privileges?
> Because I don't.

At my company we develop software for large companies and we never require DBA nor RESOURCE privileges. To run the install script, we normally only require CREATE TABLE (and other CREATE privs like SEQUENCE, TRIGGER etc).

Thomas Received on Mon Apr 09 2007 - 05:11:02 CDT