2 Replies Latest reply: Mar 28, 2013 5:53 AM by Osama_Mustafa RSS

    Fga Oracle 11g

    luix97
      Hi everybody I have enabled FGA in oracle database 11g, i want to know when the policies was created , is possible?
        • 1. Re: Fga Oracle 11g
          Marcus Rangel
          I'm not sure if I understand the question. If you mean the creation date for the policies that you see on DBA_POLICIES, here it is:
          select u.name OWNER, o.name, r.pname, o.ctime CREATED, r.pfschma, r.ppname, r.pfname
          from   sys.user$ u, sys.obj$ o, sys.rls$ r
          where  u.user# = o.owner#
          and    r.obj# = o.obj#;
          • 2. Re: Fga Oracle 11g
            Osama_Mustafa
            i hope this what you looking for
             SQL> select DB_USER,OS_USER,POLICY_NAME,SQL_TEXT, TIMESTAMP from dba_fga_audit_trail where POLICY_NAME='Name';