HOW TO SHOW ALL OBJECTS PRIVILEGES FOR A USER IN AN ORACLE DATABASE
Here is a query to a data dictionary table for finding out all the object grants that a particular user has. It includes both direct privileges and privileges granted through a role.
Objects, Oracle
GETTING ALL CHILD OBJECTS WITHIN AN OBJECT
QUESTIONS How to fix “PL/SQL: ORA-00942: table or view does not exist” during compilation? How to find out all objects within another object? How to find out all table references in a specific function or procedure? How to find out in what database object a stored procedure or function…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (71)
- Account (3)
- AWR (4)
- Database Errors (7)
- Database Performance (10)
- Datapump (4)
- DBMS_SCHEDULER (2)
- Enterprise Manager (25)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (3)
- High IO Load (4)
- Historical Session Information (3)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS SETTINGS (1)
- Objects (2)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- Optimizer Statistics Advisor (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (3)
- Tablespaces (2)
- Temporary Tablespace (2)
Tags
/etc/sudoers
Account
ACTIVE SESSION HISTORY
Agent
Agent 12c Deinstall
Agent 13c Deployment
ASH
AWR
BLOCKING SESSION
Database Auditing
Database Directory
Database Performance
Datapump
DBMS_SCHEDULER
DBMS_SYSTEM
DEADLOCK
Enterprise Manager
Enterprise Manager Metrics
Failed Logins (Historical) Metric
Failed Logins Metric
GET_ENV
High IO Load
historical session information
Idle Sessions
Initialization Parameters
LOCKED(TIMED)
Object Grants
OEM
OEM 12.1.0.4
OEM 13.1.0.0.0
OMS
Processes
Repository
ROW LOCK
Schema Statistics
Sessions
spfile
SQL_ID
STANDARD EDITION
Standard Query
Statspack Snapshots
TRANSACTION
UTL_FILE
WAITING SESSION
Yum