Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: difference between sys and sysman
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in news:3f5e340f$0$14559$afc38c87_at_news.optusnet.com.au:
>
> "Fly" <FLAVYK_at_YAHOO.FR> wrote in message
> news:3603986d.0309090647.52f1b2bb_at_posting.google.com...
>> Which is the principal difference between the account sys and sysman? >> TIA
Not so fast there - maybe.
One of the (not so) great things about Oracle is the fundamental coupling between a "user" a schema.
They are one and the same and there's nothing you can do about it, except for create all of these things that look for all the world like user accounts but really are only there to define a schema, and/or (worse) try using synonymns (gak)
Off hand, I don't know if SYSMAN falls into that category or not, but you've described one as a "database account" and the other as an "administrative account" which would seem to have at least some degree of similarity. Received on Thu Sep 11 2003 - 13:52:18 CDT