SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Insufficient privileges to run reports

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Insufficient privileges to run reports
Author Message
Guest






Post Insufficient privileges to run reports Reply with quote

Hi,

When I try to run reports using Report Viewer, I get the
message "ORA-00942: table or view does not exist or insufficient
privileges to access."
I can however view reports if I were logged on as SYS, but I
now need for users to log on as themselves to run these reports.

I am using DB Audit to audit an Oracle 9i database.

I have tried granting privileges to db_audit.data_audit_trail and
to db_audit.data_audit_columns, as well as to the other
tables specified in the documentation, but it still
does not work.

Can you indicate what are all the privileges required to be granted
for a user to view reports using Report Viewer?

Thanks,
Liana

Wed Nov 22, 2006 2:01 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Insufficient privileges to run reports Reply with quote

Which report are you trying to run?

: Hi,

: When I try to run reports using Report Viewer, I get the
: message "ORA-00942: table or view does not exist or insufficient
: privileges to access."
: I can however view reports if I were logged on as SYS, but I
: now need for users to log on as themselves to run these reports.

: I am using DB Audit to audit an Oracle 9i database.

: I have tried granting privileges to db_audit.data_audit_trail and
: to db_audit.data_audit_columns, as well as to the other
: tables specified in the documentation, but it still
: does not work.

: Can you indicate what are all the privileges required to be granted
: for a user to view reports using Report Viewer?

: Thanks,
: Liana

Wed Nov 22, 2006 2:17 pm View user's profile Send private message
Guest






Post Re: Insufficient privileges to run reports Reply with quote

Hi,

I am trying to run "Logon/Logoff and Resource Usage Audit."
But I get the "insufficient privileges" error for all reports
listed under the sections "System Audit Trail", "Compliance Reports" and
"Data Change Audit Trail"

Thanks,
Liana

: Which report are you trying to run?

Thu Nov 23, 2006 2:30 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Insufficient privileges to run reports Reply with quote

These are system-audit reports. The required permissions vary for different database systems. For example in Oracle anyone who needs access to these reports must have SELECT privilege on SYS.DBA_AUDIT_TRAIL and other SYS.DBA_AUDIT_xxx system views.
In SQL Server and DB2 they must have SELECT privileges for DB_AUDIT.SYS_AUDIT_TRAIL tables, in addition in SQL Server they must be valid users in the database where audit repository is stored. In ASE they need SELECT permissions for DBO.AUDIT_xxx system tables in sybsecurity database.

: Hi,

: I am trying to run "Logon/Logoff and Resource Usage Audit."
: But I get the "insufficient privileges" error for all reports
: listed under the sections "System Audit Trail", "Compliance
: Reports" and
: "Data Change Audit Trail"

: Thanks,
: Liana

Thu Nov 23, 2006 3:44 pm View user's profile Send private message
Guest






Post Re: Insufficient privileges to run reports Reply with quote

Thanks, your suggestion worked. Now I am able to run both
system-audit reports and data-audit reports.

However, I still get the error if I run the Compliance Reports...
specifically :
- Inactive Users With Active Accounts
- Users With Expired Passwords
- Users With Non-Expiring Passwords
- Users Having Administrative Privileges
- Recent Administrator Logins
- Recent Privileged Operations

Thanks,
Liana

: These are system-audit reports. The required permissions vary for different
: database systems. For example in Oracle anyone who needs access to these
: reports must have SELECT privilege on SYS.DBA_AUDIT_TRAIL and other
: SYS.DBA_AUDIT_xxx system views.
: In SQL Server and DB2 they must have SELECT privileges for
: DB_AUDIT.SYS_AUDIT_TRAIL tables, in addition in SQL Server they must be
: valid users in the database where audit repository is stored. In ASE they
: need SELECT permissions for DBO.AUDIT_xxx system tables in sybsecurity
: database.

Fri Nov 24, 2006 4:15 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Insufficient privileges to run reports Reply with quote

I am not sure which database system you are auditing. If you are working with Oracle, give them SELECT on DBA_USERS system view, in SQL Server they would need SELECT for sysusers

: Thanks, your suggestion worked. Now I am able to run both
: system-audit reports and data-audit reports.

: However, I still get the error if I run the Compliance Reports...
: specifically : - Inactive Users With Active Accounts
: - Users With Expired Passwords
: - Users With Non-Expiring Passwords
: - Users Having Administrative Privileges
: - Recent Administrator Logins
: - Recent Privileged Operations

: Thanks,
: Liana

Fri Nov 24, 2006 4:32 pm View user's profile Send private message
Guest






Post Re: Insufficient privileges to run reports Reply with quote

Hi,

I am using Oracle 9i database.
Granting SELECT on DBA_USERS system view only allows me to run
'Inactive Users With Active Accounts' Compliance Report.

However, I still get the error if I run the other Compliance Reports...
specifically :
- Users With Expired Passwords
- Users With Non-Expiring Passwords
- Users Having Administrative Privileges
- Recent Administrator Logins

Thanks,
Liana

: I am not sure which database system you are auditing. If you are working with
: Oracle, give them SELECT on DBA_USERS system view, in SQL Server they
: would need SELECT for sysusers

Sat Nov 25, 2006 1:50 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Insufficient privileges to run reports Reply with quote

You may also need access to DBA_ROLE_PRIVS and DBA_SYS_PRIVS views.

: Hi,

: I am using Oracle 9i database.
: Granting SELECT on DBA_USERS system view only allows me to run
: 'Inactive Users With Active Accounts' Compliance Report.

: However, I still get the error if I run the other Compliance Reports...
: specifically : - Users With Expired Passwords
: - Users With Non-Expiring Passwords
: - Users Having Administrative Privileges
: - Recent Administrator Logins

: Thanks,
: Liana

Sat Nov 25, 2006 2:23 pm View user's profile Send private message
Guest






Post Re: Insufficient privileges to run reports Reply with quote

OK, this works for all except the following 2 compliance reports:

- Users With Expired Passwords
- Users With Non-Expiring Passwords

Liana

: You may also need access to DBA_ROLE_PRIVS and DBA_SYS_PRIVS views.

Sat Nov 25, 2006 3:14 pm
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Insufficient privileges to run reports Reply with quote

I ran an audit for the report processing and found it looking for DBA_PROFILES view. So you would need to give your users SELECT permissions for that view too. Hope this helps.

: OK, this works for all except the following 2 compliance reports: - Users
: With Expired Passwords
: - Users With Non-Expiring Passwords

: Liana

Sat Nov 25, 2006 3:27 pm View user's profile Send private message
Guest






Post Re: Insufficient privileges to run reports Reply with quote

This worked!

Thank you for all your help and for the prompt responses.

Liana

: I ran an audit for the report processing and found it looking for
: DBA_PROFILES view. So you would need to give your users SELECT permissions
: for that view too. Hope this helps.

Sat Nov 25, 2006 4:10 pm
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.