Recent content by stephenwales

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