Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sys gets a lot of its privs through roles?
"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
![]() |
![]() |