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!

Register Log in
  • Congratulations Mike Lewis 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: *

  1. upthorpe

    Extracting details of defined roles

    Well I've done it! I ended up doing a full export from the original database, reimporting into a blank database with SHOW=Y and logging to a text file. I then used notepad to edit and extract the individual SQL grants for my roles into another text file which I then ran with SQLPlus to create...
  2. upthorpe

    Extracting details of defined roles

    Not quite I think, I have an Oracle 9i forms 6i system where various roles have been defined, such as CX_ACCOUNTS which allow access to accountancy type functions (theres others like CX_STOCK, CX_SUPERUSR etc). I can find what roles are granted to each user in the way that you suggest, but I...
  3. upthorpe

    Extracting details of defined roles

    Is there any was to extract details of defined roles from an Oracle 9i database. I need to recreate them exactly in another (similar database). I've been looking at various parameters of the export utility, but I don't think I can achieve it this way.
  4. upthorpe

    Can i use the Forms/reports server instead of 9iAS ?

    Cathy, The Oracle recommended solution is three tier - you have the Oracle database server, the Oracle Apache webserver and the client machine with web browser. The recomendation is that the first two are on physically different machines, but we have both running on one Compaq DL360 server and...
  5. upthorpe

    Can i use the Forms/reports server instead of 9iAS ?

    Forms server can be used to web-enable an Oracle Forms application - we've just done it and it works extremely well accessing the Oracle App in browser (Forms 6 & Oracle 9i) - theres various configurations that need to be done for the Apache webserver (location of forms etc) but we're very...
  6. upthorpe

    Oracle Listener not starting 8.1.5 & NT4

    I'm not an Oracle expert but have used it a little. I have a Compaq server running Oracle 8.1.5 which has just developed a problem whereby the listner doesn't start and I can't connect to it from client machines or even sqlplus. On start (NT4 server), Windows reports the following error in...
  7. upthorpe

    Oracle forms - opening a new form with data

    I have two V6 oracle forms which display data from tables. On a mouseclick on form 1, I have created a trigger to store two key fields in global variables and open form 2. I have created a trigger in the second form to display these key values, but what I really would like to do is to use them...

Part and Inventory Search

Back
Top