Re: How do you grant connection permission to a user?

Niall Litchfield wrote:

> "Jack" <nospam_at_nospam.com> wrote in message
> news:HYDAa.1256$LM3.317578_at_news2.telusplanet.net...
> > If you drop DBA role, you will be performing admin work thru sys or
> system?
>
> Absolutely.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************

Come on Niall you know better than that. You just create a role within your organization for DBAs and assign only the privileges required. There is never a need to hand out SYS an SYSTEM.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)