Re: Start SQL*ReportWriter V1.1

snrxu_at_reading.ac.uk (Xu Shi-lin) writes:

>
> Hi,
>
> Could anyone give me a hand in solving the following
> problems?
>
> I am going to use Oracle ReportWriter with the
> command
>
> %sqlrep username/password
>
> and what I get is an error message saying
>
> Unable to access the SQL*ReportWriter V1.1 tables. They must be
> installed in your account, or you must be granted access to them,
> before using SQLREP.
>
> This may be just a simple problem but my system manager
> just begins to manage it and cannot find how to grant access
> for me. Could you please point the way so that we cannot
> solve it?
>
> Thanks in advance
>
> Shilin
>
>
>

There are several things you can check. First and foremost, make sure that the product was installed correctly. Mare sure the SYNONYMS and GRANTS are correct and inplace. Next, there is a script in the $ORACLE_HOME/sqlreport/admin area that is designed to change the configuration or add users etc. That would be the next place to look. When all else fails use the shotgun method. Grant select, insert,update,delete to all SRW_% tables.

• Hope this helps,

                        Kirk.

---
kstarr_at_sytex.com (Kirk Starr)
Access <=> Internet BBS, a public access internet site
Sytex Communications, Arlington VA, 1-703-528-4380