Re: sysdba role in script

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, Received on Thu Feb 08 2007 - 11:48:03 CST