Autentifikacija korišćenjem pasvord datoteke

Provera inicijalizacionih parametara. 1

Kreiranje korisnika. 1

Dodela sysdba privilegije. 1

Provera specificiranih korisnika u datoteci 1

Primer lokalne konekcije. 2

Primer remote konekcije. 2

Provera inicijalizacionih parametara

SQL> show parameter passw

NAME TYPE VALUE
------------------------------------ ----------- ---------
remote_login_passwordfile            string      EXCLUSIVE

Kreiranje korisnika

SQL> create user big_admin identified by big_adminpwd default tablespace users;

User created.

Dodela sysdba privilegije

SQL> grant sysdba to big_admin;

Grant succeeded.

Provera specificiranih korisnika u datoteci

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP

------------------------------ ----- -----

SYS                            TRUE  TRUE

APPADMIN                       TRUE  FALSE

BIG_ADMIN                      TRUE  FALSE

Primer lokalne konekcije

sqlplus

Enter user-name: big_admin/big_adminpwd as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Primer remote konekcije

sqlplus

Enter user-name: big_admin/big_adminpwd@apex as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options