|
|
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 9 17:38:03 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> select open_mode from v$database ;
OPEN_MODE
--------------------
READ WRITE
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 131
Next log sequence to archive 135
Current log sequence 135
SQL> alter system switch logfile;
System altered.
SQL> conn hr/oracle_4U
Connected.
SQL> select count(*) from sh.sales;
select count(*) from sh.sales
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select count(*) from sh.sales;
COUNT(*)
----------
918843
SQL> grant select any table to ops$oracle with admin option;
Grant succeeded.
SQL> select count(*) from sh.sales;
select count(*) from sh.sales
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> revoke select any table from ops$oracle;
revoke select any table from ops$oracle
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> select count(*) from sh.sales;
COUNT(*)
----------
918843
SQL> grant select on sh.sales to ops$oracle with grant option;
Grant succeeded.
SQL> select count(*) from sh.sales;
select count(*) from sh.sales
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> /
select count(*) from sh.sales
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from session_roles;
ROLE
------------------------------
RESOURCE
SQL> set role RESOURCE,r1;
Role set.
SQL> set role dba;
set role dba
*
ERROR at line 1:
ORA-01924: role 'DBA' not granted or does not exist
SQL> select count(*) from sh.sales
2 ;
COUNT(*)
----------
918843
SQL> grant r1 to ops$oracle with admin option;
Grant succeeded.
SQL> select count(*) from sh.sales;
COUNT(*)
----------
918843
SQL> conn hr/oracle_4U
Connected.
SQL> select count(*) from sh.sales;
select count(*) from sh.sales
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> show user
USER is "HR"
SQL> select * from dba_users;
select * from dba_users
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from dba_users;
select * from dba_users
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> conn hr/oracle_4U
Connected.
SQL> select * from dba_users;
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
HR 85 OPEN 26-DEC-14 USERS TEMP 23-MAY-13 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
SH 88 OPEN 05-JAN-15 USERS TEMP 23-MAY-13 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
OPS$ORACLE 95 EXTERNAL OPEN USERS TEMP 07-JUL-14 DEFAULT DEFAULT_CONSUMER_GROUP
N EXTERNAL
U1 94 OPEN 03-JAN-15 USERS TEMP 07-JUL-14 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
SPATIAL_WFS_ADMIN_USR 67 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
SPATIAL_CSW_ADMIN_USR 70 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
APEX_PUBLIC_USER 76 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
OE 86 EXPIRED & LOCKED 23-MAY-13 23-MAY-13 USERS TEMP 23-MAY-13 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
DIP 14 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
IX 87 EXPIRED & LOCKED 23-MAY-13 23-MAY-13 USERS TEMP 23-MAY-13 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
MDDATA 65 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
PM 89 EXPIRED & LOCKED 23-MAY-13 23-MAY-13 USERS TEMP 23-MAY-13 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
BI 90 EXPIRED & LOCKED 23-MAY-13 23-MAY-13 USERS TEMP 23-MAY-13 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
XS$NULL 2147483638 EXPIRED & LOCKED 15-AUG-09 15-AUG-09 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
ORACLE_OCM 21 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
SCOTT 84 EXPIRED & LOCKED 23-MAY-13 23-MAY-13 USERS TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
DBSNMP 30 OPEN 26-DEC-14 SYSAUX TEMP 15-AUG-09 MONITORING_PROFILE DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
SYSMAN 91 OPEN 26-DEC-14 SYSAUX TEMP 29-JUN-14 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
OLAPSYS 61 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
SI_INFORMTN_SCHEMA 56 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
OWBSYS 79 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
ORDPLUGINS 55 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
XDB 45 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
ANONYMOUS 46 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
N PASSWORD
CTXSYS 43 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
ORDDATA 54 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
OWBSYS_AUDIT 83 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
APEX_030200 78 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
APPQOSSYS 31 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
WMSYS 32 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
EXFSYS 42 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
ORDSYS 53 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
MDSYS 57 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
FLOWS_FILES 75 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSAUX TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
10G 11G N PASSWORD
SYSTEM 5 OPEN 05-JAN-15 SYSTEM TEMP 15-AUG-09 DEFAULT SYS_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
MGMT_VIEW 93 OPEN 26-DEC-14 SYSTEM TEMP 29-JUN-14 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
SYS 0 LOCKED 07-JUL-14 03-JAN-15 SYSTEM TEMP 15-AUG-09 DEFAULT SYS_GROUP
10G 11G N PASSWORD
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP
------------------------------ ---------- ------------------------------ -------------------------------- ------------------ ------------------ ------------------------------ ------------------------------ ------------------ ------------------------------ ------------------------------
EXTERNAL_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PASSWORD E AUTHENTI
-------- - --------
OUTLN 9 EXPIRED & LOCKED 23-MAY-13 15-AUG-09 SYSTEM TEMP 15-AUG-09 DEFAULT DEFAULT_CONSUMER_GROUP
10G 11G N PASSWORD
38 rows selected.
SQL> conn hr/oracle_4U
Connected.
SQL> select * from session_roles;
ROLE
------------------------------
RESOURCE
SELECT_CATALOG_ROLE
HS_ADMIN_SELECT_ROLE
R1
SQL> conn hr/oracle_4U
Connected.
SQL> select * from session_roles;
ROLE
------------------------------
RESOURCE
SELECT_CATALOG_ROLE
HS_ADMIN_SELECT_ROLE
SQL> set role RESOURCE,SELECT_CATALOG_ROLE, HS_ADMIN_SELECT_ROLE ,r1 ;
Role set.
SQL> select * from session_roles;
ROLE
------------------------------
HS_ADMIN_SELECT_ROLE
R1
RESOURCE
SELECT_CATALOG_ROLE
SQL> conn hr/oracle_4U
Connected.
SQL> select * from session_roles;
ROLE
------------------------------
RESOURCE
SELECT_CATALOG_ROLE
HS_ADMIN_SELECT_ROLE
R1
SQL> select count(*) from sh.costs;
select count(*) from sh.costs
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> set role RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_SELECT_ROLE,R1,r3;
set role RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_SELECT_ROLE,R1,r3
*
ERROR at line 1:
ORA-01979: missing or invalid password for role 'R3'
SQL> set role RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_SELECT_ROLE,R1,r3 identified by 123;
set role RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_SELECT_ROLE,R1,r3 identified by 123
*
ERROR at line 1:
ORA-01979: missing or invalid password for role 'R3'
SQL> set role RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_SELECT_ROLE,R1,r3 identified by r123;
set role RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_SELECT_ROLE,R1,r3 identified by r123
*
ERROR at line 1:
ORA-01979: missing or invalid password for role 'R3'
SQL> set role RESOURCE,SELECT_CATALOG_ROLE,HS_ADMIN_SELECT_ROLE,R1,r3 identified by oracle_4U;
Role set.
SQL> select count(*) from sh.costs;
COUNT(*)
----------
82112
SQL>
|
|
发表于 2014-7-14 17:22:06
