History of User privileges held

auditoracleoracle-11g-r2oracle-12c

In Oracle 12c or 11g, is it possible to fetch the history of user privileges held by a schema? Say from last two months, I might have granted different roles and privileges. I can get the current privileges the schema holds, but is it possible to know the privileges I previously granted?

Edit:
I have standard auditing enabled 'DB'. FGA is not enabled.

Best Answer

Well there is no official method of getting the list of previous privileges list of a user or a role. But my suggestion would be doing a Fine-grained auditing on the role granted to the user. Or you can do standard auditing on the role by issuing audit <role_name>; . Here please note that if you are going to audit DBA or SYSDBA roles then set audit_sys_operations parameter to TRUE. Thank you.

Related Solutions

Configure Oracle user in Enterprise Manager to CREATE VIEW on any of his tables

I'm not sure if I'm understanding your question properly. I created a user with the ability to create views for his own schema.

SQL> create user view_user identified by password default tablespace users quota unlimited on users;

User created.

SQL> grant create session, create table, create view to view_user;

Grant succeeded.

SQL> connect view_user
Enter password: 
Connected.
SQL> CREATE TABLE Members (ID number(10), Name varchar2(100), Street_No varchar2(100), ZIP number(5), City varchar2(100));

Table created.

SQL> CREATE VIEW MembersNamesOnly AS SELECT ID, Name FROM Members;

View created.

SQL>

Linux – How to create oracle user for more than one version

For a start you can use oraenv script to set PATH, LD_LIBRARY_PATH, ORACLE_BASE and ORACLE_HOME:

export ORACLE_SID=ORCL

ORAENV_ASK=NO
. /usr/local/bin/oraenv

ORACLE_SID can be parsed from /etc/oratab file. ORACLE_HOSTNAME maybe from HOSTNAME environment variable.

Best Answer

Related Solutions

Configure Oracle user in Enterprise Manager to CREATE VIEW on any of his tables

Linux – How to create oracle user for more than one version

Related Question