Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sysdba role in script
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
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.orgReceived on Thu Feb 08 2007 - 12:31:50 CST