1.
$sqlplus //from OS Prompt
enter username:
enter password:
SQL>show user //from SQL Prompt, shows the user currently
2.
$sqlplus hr //from OS prompt logs into the user asking for password
Enter password
3.
$sqlplus hr/password@orcl //from OS prompt using the user name and password along with the database you want to login
4.
$sqlplus / as sysdba // Want to be autheticated using OS level account using super user DBA Privileges and used for DBA Level tasks to do
5.
$sqlplus /nolog // starting sqlplus without authenticating as oracle user, we will not be able to run queries against that
SQL>connect user_name // connects to that user
password:
4.
$sqlplus / as sysdba // Want to be autheticated using OS level account using super user DBA Privileges and used for DBA Level tasks to do
5.
$sqlplus /nolog // starting sqlplus without authenticating as oracle user, we will not be able to run queries against that
SQL>connect user_name // connects to that user
password:
No comments:
Post a Comment