Re: Oracle privileges and Crystal Reports

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 02 Feb 2004 23:36:14 -0800
Message-ID: <1075793714.496499@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>;

-- 
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)

Received on Tue Feb 03 2004 - 01:36:14 CST