Title: RE: upgrade to AIX 5
I know this is terrible design, but the GUI was
created by a software engineering group that is seperate from the database
group. Its not scalable. So Im trying to come up with a more scalable method. I
have no power to change their gui. It rides on the database. I
m to understand, especially when you start talking about
Oracle licenses at $40K per CPU.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: Ryan
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 15, 2003 6:29
PMTo: Multiple recipients of list ORACLE-LSubject:
securit
Title: RE: upgrade to AIX 5
Ryan,
It's alter session set current_schema =
name;
Tanel.
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 1:29
AM
Subject: security without using different
user
, Dick
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 15, 2003 6:59
PM
Subject: RE: security without using
different usernames
Ryan,
What would be much better is to create the single schema
and partition the tables so that each customer's data lands
ng
different usernames
Ryan,
It's alter session set current_schema =
name;
Tanel.
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 1:29
AM
Subject: security without
EMAIL PROTECTED]
07/15/2003 05:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: security without using different usernames
I know this is terrible design, but the GUI was created
startup (
embadded in client code ).
-ak
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 15, 2003 3:29
PM
Subject: security without using different
usernames
I know this is terrible design, but the GUI
Could you maybe use v$session.osuser instead of program? That way you shouldn't even
have to rename the exe.
HTH,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Tuesday, July 15, 2003 4:19 PM
To: Multiple recipients of list ORA
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: security without using different usernames
management has handled it. namely my manager and the answer is no. Partitioning cant be done. we are ingesting data to this applicat
.Rudy
-Original Message-From: Ryan
[mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 6:29
PMTo: Multiple recipients of list ORACLE-LSubject:
security without using different usernames
I know this is terrible design, but the GUI was
created by a software engineeri
.
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 15, 2003 7:24
PM
Subject: Re: security without using
different usernames
you can create multiple roles also . So if you
have schema a,b,c and they use Z as userid
]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, July 15, 2003 7:24
PM
Subject: Re: security without using
different usernames
Ryan, To make a particular
schema the focus for a session: Alter Session Set Current_Schema = ; Better yet, instead of proliferating the same
our application is deployed on multiple remote locations. this would mean we
would have to record the osuser of each each user in each company. This
limits the ability to scale. I believe our deployment process is we send a
CD to the client and their technical support group installs it. Plus we
alr
: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
>cc:
Sent by: Subject: Re: security without using
different usernam
D]>
> cc:
Sent by: Subject: Re: security
without using different usernames
[EMAIL PROTECTED]
.com
16/07/2003 09:44
Pl
Hi
You can get the ip address as follows:
oracle:jupiter> sqlplus system/[EMAIL PROTECTED]
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
Pete,
I follow your steps to enable audit_trail = db in init.ora located in
ORACLE_HOME/dbs
and restart my Oracle database on solaris. After my database is up, I do the exact
query in your paper and results as followings:
SQL> se
What is your database version? 9i? If so you are probably using the SPFILE;
changing the init.ora file wouldn't help.
Shutdown trhe database and startup with the pfile option
startup pfile=init.ora
being in the same directory. You will be able to see the parameter being
set.
HTH.
Arup Nanda
--
Arup,
My database version is Oracle 9i (9.2.0.1.0). Thanks!
Don
Arup Nanda wrote:
> What is your database version? 9i? If so you are probably using the SPFILE;
> changing the init.ora file wouldn't help.
>
> Shutdown trhe database and startup with the pfile option
>
> startup pfile=init.ora
>
:59:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: security without using different usernames
>
> Some time in the past year or so I was reading an article about a similar
> problem where they needed to change behavior based on where the connection
20 matches
Mail list logo