Re: Forms - as sysdba
Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. Does anyone know if/how is it possible? Yes, you could do this by creating an ON-LOGON trigger. But this is a really, really bad idea. Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] 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: [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).
Re: ADMIN: Warning about virus threats this week
Bruce A. Bergman wrote: Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists. In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends. Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to. Not only is that useless, but it's also annoying for those whose addresses have been spoofed. By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you. This is very much appreciated. I can filter the actual worms out, but I'm getting walloped by responses to spoofed worm emails. It's nice to know there's at least one place deliberately not sending them. Thanks, Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] 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: [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).
Re: select strings with '_' in it
Tanel Poder wrote: Hi! I think translate is overkill here. Use: select col from tab where col like 'v\_lan' escape '\'; vs Select col1 from table where translate(col1,'_','#') like 'v#lan%' / Not only is the escape method cleaner, it's much more efficient. Unless you have an index on translate(col1,'_','#') (unlikely), that query will always result in a sequential scan. Ugh. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] 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: [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).
Re: Tracing a user session with multiple database connections
Schauss, Peter wrote: Is there any way to trace all of the connections for a given sid without setting sql_trace for the entire instance? You could try creating a trigger to do it. create trigger foo after login on database ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] 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: [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).
Auth via Active Directory
Is there any way to get Oracle 8i (or 9i; we're planning to upgrade)
Enterprise Edition to authenticate against Active Directory, short of
buying Oracle Advanced Security?
My goal is to remove the need to maintain a separate database of
passwords. Ideally, we could do also do away with having the database
users enter passwords by handling Kerberos tickets, but I'd be happy
with them just entering the same password they enter to login to
Windows. And if we still need to manually add/remove users, that's okay,
too. (We'd probably want to, anyway; not everyone in the domain should
have an Oracle account.)
In my fantasy world, authentication would all be done through a function
that I could modify. Then I could just create my users with something like:
create user DOMAIN\USER identified externally;
as you would for OS$ authentication and then do something vaguely like:
create or replace function system.my_authenticate_user (
p_username in varchar,
p_password in varchar
) return boolean as
v_usertype varchar2(30);
v_session dbms_ldap.session;
begin
selectauthtype
from dba_users
where username = p_username;
if authtype = 'EXTERNAL' then
v_session := dbms_ldap.init('my-domain-controller', 389);
return dbms_ldap.simple_bind_s(v_session, p_username,
p_password);
end if;
return standard_authenticate_user(p_username, p_password);
exception
when no_data_found
return false;
end;
/
show errors
but I'm not aware of any such hook. There are logon triggers, but just
of the after type, not instead of. (create trigger ... after logon on
database or something, for audit trails, I think.)
Does anything like this exist? Or is there another way, however convoluted?
Thanks,
Scott Lamb
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Lamb
INET: [EMAIL PROTECTED]
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: [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).
