Re: newbie

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 23 Apr 2003 19:05:42 GMT
Message-ID: <3EA6E2E5.6FDC433D@telusplanet.net>

kent wrote:

> what's the difference between sys and system.

Theoretically SYS owns the base dictionary definitions. SYSTEM generally has [read only] views against that dictionary. SYSTEM has roughly the same 'power' as SYS but is a bit safer since you can't affect the core dictionary without deliberately going out of the way to do so.

Another way to look at it - SYS belongs to Oracle, SYSTEM to the rest of us. (In other words - don't mess wth it).

If you understand UNIX, look at it this way - SYS = root with full kernel access, SYSTEM = root + aliases to ensure you can not edit the kernel. Received on Wed Apr 23 2003 - 14:05:42 CDT