Re: fine-grained auditing

On Aug 31, 10:55 am, Oraculo01 <cesar.casti...@xxxxxxxx> wrote:
There is also a link to an example in the documentation in the blog
entry which should also list the required privileges. You will need
to have execute on the dbms_fga package for any of this to work.

David Fitzjarrell

That's what I was afraid of. I'll ask our DBA.
Thank you!

Normally when the package is created the necessary permissions are
granted to the EXECUTE_CATALOG_ROLE. You may, then, have two
problems:

1) the DBMS_FGA package has not been created.
2) the user account creating the FGA policy isn't granted the
EXECUTE_CATALOG_ROLE

I agree the smart decision here is to discuss this with your DBA and
arrive at a mutually agreeable solution.


David Fitzjarrell

.

Relevant Pages

  • Re: SQL Security
    ... I do not think it normal that the DBA sa "sa-ed" anything. ... the sa account is you assign a strong password and put it in the fire safe. ... "Joe Horton" <horj235 at lni dot wa dot gov> wrote in message ... Having sa-ed package and a 'good' service account you can ruin the server ...
    (microsoft.public.sqlserver.dts)
  • Re: grant execute on package by DBA
    ... And DBA is NOT a PERSON, ... as "a non-DBA user" I meant a user without DBA role! ... the necessary privilege on your package to PUBLIC. ...
    (comp.databases.oracle.server)
  • Re: fine-grained auditing
    ... entry which should also list the required privileges. ... to have execute on the dbms_fga package for any of this to work. ... David Fitzjarrell ...
    (comp.databases.oracle.server)
  • Re: grant execute on package by DBA
    ... DBA is a ROLE not a PERSON!! ... package I create this function unpackaged and just return in the body ... Then I can grant execute only on this unpackaged function/procedure. ... -- Grants for Function ...
    (comp.databases.oracle.server)
  • Re: DTS Package Migration in SQL 2000
    ... If you save your DTS package as a Structured Storage File, ... the DTS package, I almost always use Structured Storage Files. ... I cannot script and hand over it to my DBA. ...
    (microsoft.public.sqlserver.dts)