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

Home -> Community -> Usenet -> c.d.o.server -> Re: sys gets a lot of its privs through roles?

Re: sys gets a lot of its privs through roles?

From: Anette Hansen <Info_at_AHa-EDV.de>
Date: Thu, 19 Jul 2001 13:00:31 +0200
Message-ID: <9j6ekf$g0n$1@ds10701a.msro.detemobil.de>

"Doug C" <dcowles_at_i84.net> schrieb im Newsbeitrag news:514dltot824b08qnst8sokufm5o2p4lvef_at_4ax.com...
> It appears to me that sys does not have an extremely large amount of
 directly
> granted system privileges. Sys can grant itself anything of course, but
 quite a
> few ditties come through roles. Just out of curiousity.. why is this?
 Why
> doesn't it just have the whole enchilada?
>
> - D

Hello,

the cause is sys should not be a used user, it's reserved for Internal usage.
Create your own user with dba_privs And create rols for staff user a.s.o

Regards, Anette Received on Thu Jul 19 2001 - 06:00:31 CDT

Original text of this message

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