Re: SQL*PLUS - SET AUTOTRACE ON problems

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Thu, 7 Aug 2003 12:39:54 +0000 (UTC)
Message-ID: <bgthaq$ps8$1@srv.cyf-kr.edu.pl>

Randy Nichols <randynichols_at_yahoo.com> wrote:
> Perhaps that is the problem.

> I've never been clear on the difference between "SYSTEM" and "SYS". Can you
> point me to a good discussion or describe it?

SYS is the owner of system objects (v_$session, ...). SYSTEM can only access these objects.
So only SYS can grant object privileges like 'select on v_$session to plustrace'.

Greetings,
LW Received on Thu Aug 07 2003 - 07:39:54 CDT