Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle privileges and Crystal Reports
"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 UKReceived on Tue Feb 03 2004 - 02:52:29 CST