Search results for query: *

We run 4 different production instances of Ellipse here (5.2.1.6) We're having a problem with BEC job numbering in 2 of the 4 with users with very similar usernames. In one instance, whenever user WARNEM runs a job we see this: This is from programs_12666.log...

Hmmm, that's going to cover 95% of my access issues, I think. However: This won't protect me from a user connecting to the Unix database via SQL*Plus for Windows. Any other thoughts? However, I will play with the PUP table and have a star. Steve

I have a user account that I want to only connect from a certain application and I want to reject logins from SQL*Plus. Is there a way to create a logon trigger to check the name of the account and the method of connection (sqlplus from Unix or SQLPLUS.EXE from Windows) and if that's true, boot...

Hmmm, looks like it was just that when we recently updated Oracle to 9.2.0.7 that it had rebuild classes12.zip (or updated it) with default permissions of 640. The user running the java program could not read the file. Thanks to those who responded. Steve

I have inherited a java program that extracts data out of an Oracle 9i database and writes a flat file with some data. I need to make a slight modification to the name of the view that it extracts data from so we can perform some testing. Unfortunately, I know jack about Java. I'm thinking...

I have inherited a java program that extracts data out of an Oracle 9i database and writes a flat file with some data. I need to make a slight modification to the name of the view that it extracts data from so we can perform some testing. Unfortunately, I know jack about Java. I'm thinking...

I have a database in Paradox that I'd really like to convert to MySQL. I'm wondering if anyone has done it before and if there's some nifty tools that might be available. For starters, I'd like to be able to examine the table structure and create a "CREATE TABLE" and "CREATE INDEX" statements...

I don't disagree with anything you've said. (And, for the record, the SOX officer used to be an auditor, he was hired to think like an auditor so that we can pass our audits by running things past him first) However, I'm being told what I have to do - I'm very annoyed at the whole thing, but...

Well, I'd appreciate any pointers to other reference material. We are a small shop, 2 Oracle DBA's total, running on HPUX. So Windows Event Logs don't help me here. I have system level auditing turned on to track what a SYSDBA does. Perhaps we need to be defining our setup a little different...

We are in the process at the moment of doing a very large segregation of duties among all stuff in our IT department. As a part of this, our auditors want to restrict the DBA’s access to production databases. For example (quoted from our Sarbanes Oxley Compliance Officer)...

Yeah was thinking about something like that. Maybe I'll just go that way :) Thanks

Oh, further information (apart from the title saying SSD instead of SSH....): Initiating server is a Superdome running HP-UX 11.11 The server we're remoting to is a K-570 running HP-UX 10.20.

One of the members of the application development group here currently has a job that runs periodically where the first step is to run a remsh command to invoke a script on a remote server that queries a database, writes a file and FTP's it back to the invoking server. Recently, after an audit...

It's a low priority issue, I'll talk to the user and see how big of a deal it is - if it's really worth all that Dev time to get around a very rarely used search. Thanks Steve

Unfortunately, since I need to differentiate between a base number like "5" and a modifier of say, "+5", I didn't see any way to do that without going alpha. If I do numeric fields, they effecively become the same thing. So, am I totally up the creek then? Steve

I have a field in a Paradox table that is stored as an Alphanumeric. It was done this way so that values without a sign, and with signs, both "-" and "+" could be displayed without special code. Values could be: 1, 5, -2, +3 etc. Now, it's coming to bite me in the behind. I have a user of...

Yes, but that's the TP, unfortunately, I don't believe that CICS has a similar setting, or at least we haven't found one yet. Steve

We are running TX-Series CICS 5.0.0.4 on HP-UX 11.11. We have about 15 CICS instances running on this server at any one time. From time to time, it appears as if one of the regions stops accepting communication from the telnet connection, even though looking at the console log and the server...

I don't have a 32 bit version to play with, but when I do a select * from v$version, I get the following (bolding mine): SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production PL/SQL...

Been bringing up a new system, under CICS 5.0, on HPUX 11.11, Oracle 9.2.0.5 for Ellipse 5.2.1.4. The users are reporting that they walk away from the keyboard for 30 minutes and come back and hit enter and they get a message about the session being disconnected. I know I've seen this before...