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

Thread: Users Tablespace

  1. #1
    Join Date
    Mar 2003
    Posts
    29

    Users Tablespace

    Hi All,

    Got a silly question on the USERS TS.

    I support an application that has the USERS TS hardcoded into it if you dont have a users TS in your DB it you have to make use of scripts to do most of the work - you generate these scrits in the app, then modify the TS name in there and run it on the db.

    OK - I did not write this app - it seems that the developers who did are all MSSQL guys who woke up one morning and said "Hey lets write some oracle stuff" resulting in a DB app that does not make use of Bind variables, has the USERS TS hardcoded in it etc etc.

    It is not funny!

    Anyway I have to support this and mostly it works fine.

    The Problem
    We have a customer who refuses to make use of the USERS TS - in fact they have removed this from the DB, reason being it is a security risk.
    I just think they are being stupid but would appreciate it if one of you more experienced guys could confirm that this is correct or false and why?

    Thanks

    J

  2. #2
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Hello,

    I'm not a very experienced user, but I read a lot about Oracle. What I can say is: I think it's another urban legend.

    Oracle's security is tight. If you don't trust the standard security system, you can invest in an extra Oracle security product for your db. Try and hack that!

    If you have questions, consult metalink. All the answers on security risks are there to be found.

    HTH,

    Erik
    Last edited by efrijters; 05-28-2003 at 06:00 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Not sure how they can claim the USERS tablespace is any less secure than any other tablespace. It's not created in any special way, if that is there thinking then every tablespace they have is insecure and they better store thier data under the bed

    Sounds like you just have a stubborn client
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    USERS!!!

    USERS!!!

    What the "F" do they know about database administration. SHOOT THEM!!
    Give me a friggin break!
    Tell them to document this and share it with all of us. I want to know how a tablespace name is a "security breach" .

    USER is a four letter word.

    Sorry, I just had help desk flashbacks, my medication is kicking in now, carry on.

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Ps. Shoot the damn developers too, hard coding a TBSP name is just cause for a severe beating, getting it into production!!?? SHOOT THEM!!

    With love,
    MH
    I remember when this place was cool.

  6. #6
    Join Date
    May 2001
    Posts
    736
    Now i know why everone wants MH when they are upset with their developers.

  7. #7
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Better watch the old blood pressure there MH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  8. #8
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    DEVELEOPS CHARTER OF RIGHTS
    > The dba is god, you are dirt
    I'm stmontgo and I approve of this message

  9. #9
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    Originally posted by Mr.Hanky
    USERS!!!

    USERS!!!

    What the "F" do they know about database administration. SHOOT THEM!!

    MH








    Giani

  10. #10
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by Giani








    This is a good start but we need more heavily armored vehicles with bigger guns please.

    MH
    I remember when this place was cool.

Posting Permissions

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


Click Here to Expand Forum to Full Width