Kontrola prefixu
SQL> show parameter authent
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix string ops$
remote_os_authent boolean FALSE
OS user
[root@oel64 ~]# useradd hacker
[root@oel64 ~]# passwd hacker
Changing password for user hacker.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
DB user
SQL> create user ops$hacker identified externally;
User created.
SQL> grant connect to ops$hacker;
Grant succeeded.
Kontrola
[hacker@oel64 ~]$ id
uid=54322(hacker) gid=54324(hacker) groups=54324(hacker) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[hacker@oel64 ~]$ sqlplus /
-bash: sqlplus: command not found
[hacker@oel64 ~]$ . oraenv
ORACLE_SID = [hacker] ? orcl12c
Resetting ORACLE_BASE to its previous value or ORACLE_HOME
The Oracle base has been set to /u01/app/oracle/product/12.1.0/dbhome_1
[hacker@oel64 ~]$ /u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlplus /
SQL*Plus: Release 12.1.0.1.0 Production on Wed Nov 13 19:56:48 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL>
Uživatel se přihlasil bez jména a bez hesla.