DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Quick Questions

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Quick Questions

    Hello all,

    A question on the /as sysdba login. Is there anyway this can be more secure? This has caused a security issue with us as anyone who knows this loop-hole can log into the database as with dba privs!.

    My second question is, are there any logs/views for info on things like user password changes during a particular window??

    Many Thanks in advance,
    Chucks_k.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    / as sysdba only works if you are in the correct group, i.e. dba on UNIX, if you are not in the correct group then this wont let you in.

    To stop anyone doing it you can set something in the init.ora file, forget what it is off hand, will look it up.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Quick Questions

    Originally posted by Chucks_k
    A question on the /as sysdba login. Is there anyway this can be more secure? This has caused a security issue with us as anyone who knows this loop-hole can log into the database as with dba privs!.
    What security loop-hole? I can't see any loop-hole if you are managing your system corectly.
    My second question is, are there any logs/views for info on things like user password changes during a particular window??
    Database auditing (either the built-in one or "home made" one based on database event triggers).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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