Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mrt78
  • Order by date
  1. mrt78

    Permission to tables in the archive log

    Sorry for the short description. Yes I was using the logmnr. I have resolved the issue. I did not have the grant execute on dbms_logmnr set for the user. Thanks!
  2. mrt78

    Permission to tables in the archive log

    Sorry, I should not have stated redo-log table (typo) in my hurry.
  3. mrt78

    Permission to tables in the archive log

    I have an application that pulls updates from the archive log, but when possible (when it is not behind), it pulls the update from the redo log rather then waiting for the update to be archived. I am no DB expert, and trying to determine why a specific user does not have access to the...
  4. mrt78

    Permission to tables in the archive log

    Is there a way to limit the access to redo-log tables for a specific user? Currently I have an issue where the user is able to see updates to one table, but not the rest of the tables in the schema being archived. For now, the only reasons I can think of are that you can limit the access to...
  5. mrt78

    Multi-row comparison in triggers

    I have a trigger which was developed for single row updates, but it needs to handle multi-row updates to support 2005. The basis of the trigger is that it does a value comparison on a specific field to see if it changed and then reacts based on the change. Example: CREATE TRIGGER...
  6. mrt78

    Multiple DB2 versions on one server (is this possible)?

    Thanks! I also found out that FixPack7 for 7.x will allow me to do what I need.
  7. mrt78

    Multiple DB2 versions on one server (is this possible)?

    Would it be possible to have two versions of DB2 installed on one server, and if so, is there somewhere specific I could look for detailed instructions on doing this? Thanks, mrt78

Part and Inventory Search

Back
Top