Schema HR
Oracle Version 11.2.0.2.0
As Of 22/03/2019 08:51:43
| Parameter | Value |
|---|---|
| Default Tablespace | USERS |
| Temporary Tablespace | TEMP |
| Profile | DEFAULT |
| Account Status | OPEN |
| External Name | |
| Initial Resource Consumer Group | DEFAULT_CONSUMER_GROUP |
| # of System Privileges | 7 |
| # of Roles | 2 |
| # of Tablespace Quotas | 1 |
| # of Object Privileges | 1 |
| Parameter | Value |
|---|---|
| Composite Limit | UNLIMITED |
| Failed Login Attempts | 10 |
| Sessions Per User | UNLIMITED |
| CPU Per Session | UNLIMITED |
| CPU Per Call | UNLIMITED |
| Logical Reads Per Session | UNLIMITED |
| Logical Reads Per Call | UNLIMITED |
| Idle Time | UNLIMITED |
| Private SGA | UNLIMITED |
| Connect Time | UNLIMITED |
| Password Life Time | UNLIMITED |
| Password Grace Time | 7 |
| Password Lock Time | 1 |
| Password Reuse max | UNLIMITED |
| Password Reuse Time | UNLIMITED |
| Password Verify Function | NULL |
| Object Type | Count | Details |
|---|---|---|
| Sys Privs Granted to User | 7 | |
| Roles Granted to User | 2 | |
| Tablespace Quotas Granted to User | 1 | |
| Object Privileges Granted to User | 1 | |
| Sys Privs Granted to Roles | 9 | |
| Roles Granted to Roles | 0 | |
| Tables | 8 | 40 columns |
| 40 lobs | ||
| 39 constraints | ||
| 0 partitions | ||
| 0 subpartitions | ||
| Indexes | 20 | 24 columns |
| 0 partitions | ||
| 0 subpartitions | ||
| Audit Policies | 0 | |
| Views | 1 | 16 columns |
| Materialized Views | 0 | |
| Materialized View Logs | 0 | |
| Queues | 0 | |
| Queue Tables | 0 | |
| Redaction Policies | 0 | |
| Triggers | 2 | |
| Types | 0 | |
| Type Bodies | 0 | |
| Functions | 0 | 0 lines of code |
| Procedures | 2 | 22 lines of code |
| Packages | 0 | 0 lines of code |
| Package Bodies | 0 | 0 lines of code |
| Sequences | 3 | |
| Synonyms | 0 | |
| DBMS Jobs | 0 | |
| Scheduler Jobs | 0 | |
| Scheduler Programs | 0 | |
| Scheduler Schedules | 0 | |
| Scheduler Credentials | 0 |
| Object Type | Object Owner | Object Name | Column Name | Grantable Privileges | Non-Grantable Privileges |
|---|---|---|---|---|---|
| Package | SYS | DBMS_STATS | EXECUTE |
| Privileges | Admin Option |
|---|---|
| ALTER SESSION | No |
| CREATE DATABASE LINK | No |
| CREATE SEQUENCE | No |
| CREATE SESSION | No |
| CREATE SYNONYM | No |
| CREATE VIEW | No |
| UNLIMITED TABLESPACE | No |
| Role Name | Default Role | Admin Option |
|---|---|---|
| CONNECT | Yes | No |
| RESOURCE | Yes | No |
| Tablespace | Quota |
|---|---|
| <All> | Unlimited |
| USERS | Unlimited |