Re: alter session

Bulbul,

I think I answered this question of yours a few days ago. For setting sql_trace, the user must have ALTER SESSION system privilege; for all other session altering statements like 'alter session set nls...', etc., the use does not need to have alter session privs. In your case, you have not given the user SCOTT the needed priv 'alter session'. So, SCOTT can alter session to set nls_lang, but not enable sql_trace.

HTH. Arup Nanda
www.proligence.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, May 19, 2003 5:57 PM

> Dennis As I asked in my original question , how would plustrace role
explain
> the fact that
> I create a user scott
>
> and then gave him create session, create table privileges only.
>
> Why is he able to do
>
> alter session set nls_date_format='dd-mon-yyyy' ;
>
> and
>
> alter session set nls_language=French;
>
> but he is unable to
>
> alter session set sql_trace=true ;
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, May 18, 2003 09:41
>
>
> > As sys, execute the script $ORACLE_HOME/sqlplus/admin/plustrce.sql
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Saturday, May 17, 2003 9:08 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > which role is plustrace ? it doesn't seem to be an Oracle predefined
role
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, May 07, 2003 01:38
> >
> >
> > Give the user the plustrace role as follows:
> >
> > SQL> grant plustrace to j_smith;
> >
> >
> >
> > -----Original Message-----
> >
> > Sent: Tuesday, May 06, 2003 2:28 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Hi list
> >
> > I create a user scott
> >
> > and then gave him create session, create table privileges only.
> >
> > Why is he able to do
> >
> > alter session set nls_date_format='dd-mon-yyyy' ;
> >
> > and
> >
> > alter session set nls_language=French;
> >
> > but he is unable to
> >
> > alter session set sql_trace=true ;
> >
> >
> >
> > Is it because nls parameters are client side and sql_trace affects the
> >
> > server side ?
> >
> >
> >
> > --
> >
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >
> > --
> >
> > Author: <bulbultyagi_at_now-india.net.in
> >
> > INET: bulbultyagi_at_now-india.net.in
> >
> >
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >
> > San Diego, California -- Mailing list and web hosting services
> >
> > ---------------------------------------------------------------------
> >
> > To REMOVE yourself from this mailing list, send an E-Mail message
> >
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >
> > the message BODY, include a line containing: UNSUB ORACLE-L
> >
> > (or the name of mailing list you want to be removed from). You may
> >
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: <bulbultyagi_at_now-india.net.in
> > INET: bulbultyagi_at_now-india.net.in
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).