Thursday, October 30, 2008

Granting SYSDBA adds an entry to the password file

SQL> grant sysdba to robert;

Grant succeeded.

SQL> connect robert as sysdba
Enter password:
Connected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

[t-dev-oranode-50.cmc.local:dv1]$ diff orapwapex.bak orapwapex
< Z[\]ORACLE Remote Password fileNTERNA232A4CC5194A53EESYSDCB748A5BC5390F2
---
> Z[\]ORACLE Remote Password fileNTERNA232A4CC5194A53EESYSDCB748A5BC5390F2ROBERT6D938DC70DAA0F72