Re: sqlplus small doubt

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 29 Jan 1999 16:38:36 -0000
Message-ID: <917627895.15269.0.nnrp-03.9e984b29@news.demon.co.uk>

Thank you for the confirmation -
Odd point, though I've just done

    select * from role_sys_privs where role='CONNECT'

on my 8.0.4, and the privileges are almost the same as the one for RESOURCE. The manual seems to be a few sausages short of a barbecue.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

    Alex Hudghton wrote in message =
<36B1DE0D.DF695DE9_at_capgemini.co.uk>...

    Not only in the archives but also in Oracle 8 SQL Reference manual     Oracle provides shortcuts for specifying groups of system privileges = and statement options at once. However, Oracle

    encourages you to choose individual system privileges and statement = options for auditing, because these shortcuts may not be

    supported in future versions of Oracle. The shortcuts are follows:

     CONNECT 
                      is equivalent to specifying the CREATE SESSION =
system privilege. 
     RESOURCE 
                      is equivalent to specifying the following system =

privileges: Received on Fri Jan 29 1999 - 10:38:36 CST