13 February 2007

What is so special about SYSDBA?

Last night in #oracle, someone new to Oracle had some confusion with the SYSDBA privilege. I proceeded to drop some science on him, but here's a basic primer:

  • Only a user with the SYSDBA privilege can startup or shutdown an instance.
  • The oracle OS user can "connect / as sysdba" without providing any further authentication. This is why you want to restrict access to that user as well. In fact, that user (and probably anyone in the dba OS group) can "connect sys/not_a_real_password as sysdba" and it will always succeed. Beware!
  • When you connect AS SYSDBA, you'll be logged in as SYS, regardless of what user you originally were connecting as.
Thanks to ADP for the resources. René has a nice resource site there and I reference it a lot, as well as his blog.

No comments:

Post a Comment