Users wanting SYS password - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 26

Thread: Users wanting SYS password

  1. #11
    Join Date
    Dec 1999
    Posts
    217
    You dont want to give them the sys password. A good "politically correct" way of saying it would be that you do not want any user to create user objects in the sys schema, thus, you cannot give it to them.
    Better still, question them till they get fed up and stop asking for it.

    -Chintz

  2. #12
    Join Date
    Jan 2001
    Posts
    3,131
    I still say shoot them!
    I remember when this place was cool.

  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    just ask, you are the DBA or I am the DBA?

  4. #14
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Write a packaged procedure to do the job for them and grant execute access to them. The procedure will run with owner rights (by default) allowing them to perform the action as if they were SYS, but what they do will be limited by the procedure you code.

    Cheers

    Tim...

    PS. I'm with Mr Hanky! Shoot them
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #15
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Mine being a small company i have faced this problem and finally gave up trying.

    The reason given by my manager is that sometimes if i am not there the other developers might need to bounce the database for some reason or if the database crashes and if i am not there then how will they get oracle support if they dont have the passwords etc etc.

    actually I REALLY WANT TO SHOOT THEM.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  6. #16
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by ronnie
    Mine being a small company i have faced this problem and finally gave up trying.

    The reason given by my manager is that sometimes if i am not there the other developers might need to bounce the database for some reason
    write some script so that you can start up and shutdown the database
    or if the database crashes
    They cannot do anything about it

    and if i am not there then how will they get oracle support if they dont have the passwords etc etc.
    What password ??

    actually I REALLY WANT TO SHOOT THEM.
    Last edited by adewri; 02-06-2003 at 11:42 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #17
    Join Date
    Jan 2001
    Posts
    3,131
    Q: How do you know if a USER is lying?

    see below...









































    A: His mouth is moving!!


    Shoot 'em!!

    MH
    I remember when this place was cool.

  8. #18
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796


    Who ever needs the password please come in line....
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  9. #19
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    It is us DBA's vs. them DAMN DEVELOPERS..

    I still recall when I was a DBA at this big company.. The development team lead is to climb and sh*t all over the dba's heads.. that is to put it mildly..

    He used to page me at 8pm.. to do a production migration urgently.. and then I migrate a little pro*c program.. it does not work obviouly.. ok.. I migrate again.. it does not work.. this goes on till 3am..

    DAMN DEVELOPERS...

  10. #20
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by ronnie
    The reason given by my manager is that sometimes if i am not there the other developers might need to bounce the database for some reason or if the database crashes and if i am not there then how will they get oracle support if they dont have the passwords etc etc.
    Our solution was the password in a sealed envelope in the safe in the CEO's office and a signout procedure (make a BIG deal of it). Things have to get bad before they ask him . . .

    Recommend NOT shooting them - it is impossible to get the blood out of the keyboard. Poison them, or better "Do it not with poison, strangle them, even on their own desks which they have contaminated" (appologies to WS).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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