Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sysdba role in script

Re: sysdba role in script

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 08 Feb 2007 10:31:50 -0800
Message-ID: <1170959511.66586@bubbleator.drizzle.com>


bofh1234_at_hotmail.com wrote:
> On Feb 8, 10:33 am, DA Morgan <damor..._at_psoug.org> wrote:

>> Why are you granting connect? What do you think that accomplishes?
>> Why are you granting resource?
>> Why are you mistakenly granting SYSDBA in place of DBA and why would
>> you grant Harry DBA had you gotten it right in the first place?
>>
>> Don't grant privileges that are unnecessary and dangerous.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

>
> I agree. I don't grant unnecessary privileges. The connect and
> resource privileges weren't used in the script I sent as that was
> phase 1. When I write scripts I break them down into small complete
> chucks. This makes debugging easier IMO. Phase 2 is when connect
> gets used. Phase 4 is when resource gets used.
>
> In a previous posting Mark said connect and resource are obsolete. Do
> you know what replaced them?
>
> Thanks,

My point is that CONNECT should NEVER be used. RESOURCE should NEVER be used.
You are granting privileges that are NEVER necessary.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Feb 08 2007 - 12:31:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US