Autentifikacija korišćenjem pasvord datoteke

Autentifikacija korišćenjem pasvord datoteke. 1

Provera inicijalizacionih parametara. 1

Kreiranje korisnika. 1

Dodela sysdba privilegije. 1

Provera specificiranih korisnika u datoteci 1

Primer lokalne konekcije. 2

Primer remote konekcije. 3

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

12c

SQL> select * from v$pwfile_users; --container db

USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID

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

SYS TRUE TRUE FALSE FALSE FALSE FALSE 0

SYSDG FALSE FALSE FALSE FALSE TRUE FALSE 1

SYSBACKUP FALSE FALSE FALSE TRUE FALSE FALSE 1

SYSKM FALSE FALSE FALSE FALSE FALSE TRUE 1

BIG_ADMIN TRUE FALSE FALSE FALSE TRUE FALSE 4

SQL> select * from v$pwfile_users; --plugable db

USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID

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

SYS TRUE TRUE FALSE FALSE FALSE FALSE 0

BIG_ADMIN TRUE FALSE FALSE FALSE FALSE FALSE 4

11g

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP

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

SYS                            TRUE  TRUE

APPADMIN                       TRUE  FALSE

BIG_ADMIN                      TRUE  FALSE

(V$PWFILE_USERS This view lists users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.)

Primer lokalne konekcije

12c

SQL> conn big_admin/big_adminpwd@pdb2 as sysdba

Connected.

SQL> shutdown immediate;

Pluggable Database closed.

SQL> startup

Pluggable Database opened.

previous version
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

SQL> show user

USER is "SYS" ----????

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

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