master group depends on the relationship among the
tables and whether they must be refreshed in one shot to maintain logical
integerity. But I almost always found it better to have a group per a table.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: "Multiple recipien
Jim,
Modify the parameter log_archive_dest_2 to "service=X optional reopen=300". Note the
keyword "optional". This will ensure that even if the archive has not created
the file at the standby location, the primary will not hang.
HTH.
Arup Nanda
www.proligence.c
locally managed with Automatic Segment Space
Managed? I have seen a slight performance degradation with the setup; but
can't prove conclusively. Un any case the performance impact on exchange
partition is slight.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of lis
have another script called call_import.sh with the follwoing lines
sqlplus -s us/[EMAIL PROTECTED] @import.sql
sh imp.sh
If the database is not test, then the imp.sh will be empty and the import
will not go through. Otherwise it will have the entire import line.
HTH.
Arup Nanda
- Origi
Gurelei
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To
the user.
HTH.
Arup Nanda
- Original Message -
From:
Jack van
Zanen
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, June 18, 2003 10:49
AM
Subject: Partitions of table read
only
Hi,
I would like to know if it is possible and what the
pitfalls a
> 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).
>
>
> __
> Do you Y
blespace,
> then tried to make it read only. It's still hanging.
>
> Oh yeah, 9.2.0.1 on Linux
>
> Rachel
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > Rachel,
> >
> > A TS can't become read only if there are active transactions against
&
Seema,
Select last_ddl_time and timestamp from user_objects where the object_name =
''
HTH
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 11:29 AM
> Hi,
>
> Is any view
s need to have a sepcific named
database user. However, that can be easily fixed by setting up an application
context and passing the app_user value to a context attribute. This attribute
can now be tracked, rather than the userid.
Hope this helps.
Arup Nanda
www.proligence.com
- Origi
sses that issue. Along with
application context, you will have the toolbox to build a complete
iron-clad authentication and authorization system.
Hope this helps.
Arup Nanda
www.proligence.com
- Original Message -
From:
Gogala, Mladen
To: Multiple recipients of list ORAC
OTD: Any clod can have facts, having an opinion is an art !
>
> (See attached file: ESPN_Disclaimer.txt)
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatc
/@service1
If it doesn't work, the OS user may be different.
Use this query while connected to the database from Windows cleint.
SQL> select sys_context('USERENV','OS_USER')
from dual;
See what OS username comes up; use that
instead.
HTH.
Arup Nanda
ww
sday, June 19, 2003 3:59
PM
Subject: Re: Re: Passwords and
authentication
what will be the name of your book? when will it be out? you
have an extract of what it will cover yet? > > From: "Arup
Nanda" <[EMAIL PROTECTED]>> Date:
2003/06/19 Thu PM 03:31:43 E
stGuru') 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://w
(203)
459-6855 Email:[EMAIL PROTECTED]
-----Original Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 19, 2003 3:46
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
oracle authentication from windows
Sure.
Just declare these in your
ser SYSTEM!
Therefore, always have a not null value in
os_authent_prefix, e.g. OPS$.
If the XP user is OPS$SYSTEM, the oracle user
should be OPS$OPS$SYSTEM, not OPS$SYSTEM. I hope you see the
difference.
HTH.
Arup
- Original Message -
From:
AK
To: Arup Nanda
Sent: Frida
gt;
> >os_authent_prefix=OPS$
> >remote_os_authent=TRUE
> >
> >bounce the database, add a user called OPS$, e.g.
> >OPS$AK if your Windows login id is AK as
> >
> >create user ops$ak identified externally
> >
> >From windows connect as "/@s
sage
> to: [EMAIL PROTECTED] (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).
>
deal, make sure they are not hardcoding
passwords in the applications, a common problem.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 9:44 AM
> This is an interesting
> to: [EMAIL PROTECTED] (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 subscrib
imary - to conserve the CPU cycles. and it
certainly helps.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 20, 2003 9:54 AM
Subject: VLDB (oltp) and RMAN
Hi Listers,
I
that, after the conenction, validates the password using the
> function and authenticates the user. If the password is not correct,
> the user is booted out.
>
> Now comes other issues - fine grained access control and fine grained
> auditing. These features need to have a sepcific
database has a user OPS$BULBUL
identified externally; a user named bulbul on the _server_ can login as
"sqlplus /", but a user named BULBUL on a remote machine will not be able
to.
Hope this helps.
Arup Nanda
www.proligence.com
- Original Message -
To: "Multiple recipients o
Nguyen,
Have you tried using SYS_CONTEXT('USERENV','')?
where may be
SESSION_USER - for the user who logins in.
IP_ADDRESS - the ip address of the client machine
OS_USER - the OS user
etc.
HTH.
Arup Nanda
- Original Message -
From:
Nguye
hem and those
> systems have to be trusted.
>
> cheers
>
> Pete
>
> In article <[EMAIL PROTECTED]>, Arup Nanda
> <[EMAIL PROTECTED]> writes
> >Pete,
> >
> >Apprciate your comments. You are right in stating that if the OPS$
accounts
> >have
re. But if a user
is authenticated using kerberos, the chances are the procedure has been
proper and therefore it might be considered acceptable.
In my forthcoming book, "HIPAA Security and Auditing for Oracle", coming out
in September, I have discussed these topics in depth and
301 - 327 of 327 matches
Mail list logo