DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Product User Profile

  1. 02-11-2004, 10:36 AM #1
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    Product User Profile

    We have a read only user on our Main production database that another database uses via a link. The password for this user account can't be altered as the developers hardcoded it into their app that uses this 2nd database.(I know, I know)

    Consequently - the developers now have access to the live database (albeit read only - 'SELECT' only on a subset of tables). They are starting to use TOAD to connect and run queries and I want to stop them. I've told them but one keeps connecting.

    Can I use PUP to prevent this access? Not sure how to create a record that would stop TOAD users connecting.

    I can't diasble the read only account nor change the password. Do i have any alternatives?
    Reply With Quote Reply With Quote
  2. 02-11-2004, 11:04 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    setup an alias that goes through a connection manager. Inside the connection manager, only allow the ip of your remote server.

    Mr. H would have have another opinion involving a S&W .45...
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 02-11-2004, 11:18 AM #3
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Ok, give me a clue
    (a) Where can I read up on that?
    (b) How much is a S&W .35?
    Reply With Quote Reply With Quote
  4. 02-11-2004, 11:26 AM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    a. http://download-west.oracle.com/docs...man.htm#488858

    b. http://www.gunsamerica.com/guns/976403546.htm
    Jeff Hunter
    Reply With Quote Reply With Quote
  5. 02-11-2004, 12:05 PM #5
    mrchrispy
    mrchrispy is offline DBA (blue belt)
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    B go for B!!!

    alternativly how about an on logon trigger that kills the session if its that USERNAME is that login and the PROGRAM is toad.exe?
    Reply With Quote Reply With Quote
  6. 02-11-2004, 12:16 PM #6
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    You boys and your guns!

    I could be sarcastic now about America and Gunchester ...

    I was thinking about the logon trigger but thought PUP might be easier. On the subject does the PUP table recognise 'TOAD'? Or is Oracle specific?
    Reply With Quote Reply With Quote
  7. 02-11-2004, 12:43 PM #7
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by JMac
    You boys and your guns!

    I could be sarcastic now about America and Gunchester ...
    Not to hijack or anything, but my co-DBA is all excited because Ohio is letting him carry a "concealed weapon" (ie. "hidden gun") in public. Just in case a MacPerson misses out the MacGerkhin from his MacBurger, presumably.

    I tell him, "Guns don't kill people, Americans kill people".
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  8. 02-11-2004, 12:48 PM #8
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    That whole country is mental.

    Hundreds of young guys are coming home in body bags just so that moron gets re-elected, and the nation is OUTRAGED at Janet Jackson's right breast.

    Get a grip people!

    (Ooer, bit of politics there.)
    Reply With Quote Reply With Quote
  9. 02-11-2004, 01:01 PM #9
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I was outraged at that breast shot -- she's really let herself go since i last saw it.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  10. 02-11-2004, 01:04 PM #10
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Ah -- obfuscation thread. Ahem

    America is mental

    Discuss:
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width