Oracleメモ

oracle memo 20080514

ORACLE_HOME、ORALCE_SIDの調べ方

$ORACLE_HOME/NETWORK/ADMIN/lisner.ora

権限付与 grant [権限] to [ユーザ]

権限剥奪 revoke [権限] from [ユーザ]

異なる権限で接続 sqlplus [ユーザ]/[パスワード]@[SID] as [権限]

sqlplus sys/oracle@orcl as sysdba