Re: need some help

Mark C. Stock wrote:
> However I saw one of your scripts (audit_last_logon.sql) that I can use,
> | I've been testing it but keep getting the error "table or view doesn't
> | exist" (dba_audit_session).
> | What must I do to resolve this problem?
> | Thanx in advance.
> |
> |
>
> in case peter doesn't see this before your paper is due...
>
> if your account does not have select priv on the DBA_AUDIT_SESSION view,
> and/or your system dies not have a public synonym for SYS.DBA_AUDIT_SESSION,
> you will get the error
>
> i've not seen the script you refer to, but perhaps you could use
> USER_AUDIT_SESSION instead
>
> -- mcs

That and hope that unlike me, the OPs instructor isn't watching. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)