Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle privileges and Crystal Reports

Re: Oracle privileges and Crystal Reports

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 3 Feb 2004 08:52:29 -0000
Message-ID: <401f614e$0$9390$ed9e5944@reading.news.pipex.net>


"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1075793714.496499_at_yasure...
> kris p wrote:
>
> >>Truth in all of it. Have your DBA verify you have the permissions
required.
> >
> >
> > Thanks for your reply. What permission/role/privilege exactly is
> > it that allows looking at tables outside the current user's schema?
> >
> >
> >>And dump ODBC and use Crystal's native Oracle connectivity.
> >
> >
> > Can't do that, set in stone :-|
> >
> > kristoff plasun
>
> GRANT select ON <table_name> TO <schema_name>;

Or grant select on <table_name> to <role_name>; PUBLIC would be my suspicion here.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Feb 03 2004 - 02:52:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US