RE: alter session

Paul, Not true. It has no effect on privileges. If you can't access the table normally using alter session won't change that. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Paul Drake [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003

RE: alter session

That only affects how Oracle finds objects. If for instance you would have to access dba_users normally as sys.dba_users then using the alter session command means you can drop the 'sys.' portion thereof. It has no affect on your priviledges. Down side is that if you then want to reference

Re: alter session

Goulet, Dick wrote: That only affects how Oracle finds objects. If for instance you would have to access dba_users normally as sys.dba_users then using the alter session command means you can drop the 'sys.' portion thereof. It has no affect on your priviledges. Down side

alter session

List, what does the following do ? alter session set current_schema=sys; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: alter session

recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 4:44 PM List, what does the following do ? alter session set current_schema=sys; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City

Re: alter session

Exactly what it says: set the current schema to sys At 05:44 PM 10/8/2003, you wrote: List, what does the following do ? alter session set current_schema=sys; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network

Re: alter session

: List, what does the following do ?alter session set current_schema=sys;-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: <[EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and

RE: alter session

Well my blood pressure has been raised by alter session set current_schema = ... today. Here are a couple of interesting things I have found about that feature: Case A) If you sign on as userA, set current_schema to userB, then use dbms_sql to 'create table t': in 7.3.4 and 8.0 - table

ALTER SESSION SET EVENTS '...'

I often met SQL phrase in sql scripts as ALTER SESSION SET EVENTS '...' for example: ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10'; (Oracle 8.1.7.3 patches install instuctions) or alter session set events '10046 trace name context forever, level Level'; where

Re: ALTER SESSION SET EVENTS '...'

: a.ruSubject: ALTER SESSION SET EVENTS '...' Sent

Re: ALTER SESSION SET EVENTS '...'

: a.ruSubject: ALTER SESSION SET EVENTS '...' Sent by: root@fatcity

Re: ALTER SESSION SET EVENTS '...'

: ALTER SESSION SET EVENTS '...' Sent by: root@fatcity

Re: alter session set events 'immediate trace name redohdr level 10'

Hagedorn, Linda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/01 03:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:alter session set events 'immediate trace name redohdr level 10

alter session set events 'immediate trace name redohdr level 10'

Title: alter session set events 'immediate trace name redohdr level 10' Hello, I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example, siz: 0x5000 seq: 0x1087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2 The size parameter

Re: alter session set events 'immediate trace name redohdr level 10'

To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:alter session set events 'immediate trace name redohdr level 10' Hello, I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example, siz: 0x5000

RE: alter session set events 'immediate trace name redohdr level

] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 3:07 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alter session set events 'immediate trace name redohdr level 10'Hi Linda Welcome to Oracle! I am aware that db2 has wealth of documentation and manuals, but you would

alter session over database link

Rather than increase the sort area size for everyone I need to alter the sort area size for the session but how do I do this for the session over the database link? Any help is appreciated, Dave Turner -- And you thought

ALTER SESSION SET NLS_DATE_FORMAT

Hello: Can anyone explain to me what exactly 'Alter Session' will do? Will it alter the session all the way until it close? How do I find out what kind of mode is my SQLPLUS session currently on? I have following script like: ALTER SESSION SET NLS_DATE_FORMAT = '-MM-DD-HH24.MI.SS';SELECT

RE: ALTER SESSION SET NLS_DATE_FORMAT

Title: RE: ALTER SESSION SET NLS_DATE_FORMAT -Original Message- From: Wendy Y [mailto:[EMAIL PROTECTED]] Can anyone explain to me what exactly 'Alter Session' will do? Will it alter the session all the way until it close? How do I find out what kind of mode is my SQLPLUS session

Re: ALTER SESSION SET NLS_DATE_FORMAT

It will set the NLS_DATE_FORMAT for that session only. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 1:10 PM Hello: Can anyone explain to me what exactly 'Alter Session' will do? Wil

Alter session, NLS parameters

Hello list, Is there a possibility to know a specific session's NLS parameters querying from another session ? Regards, Radu Caulea Senior Oracle Consultant www.caulea.fr.st -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Radu Caulea INET: [EMAIL PROTECTED] Fat