Re: help with read-only user

        As the owner of the tables, not the tablespace, but the tables you are willing to let the Crystal Reports users access

        GRANT SELECT ON table name TO reader;

Write a script that will do it for each table.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/10/00, 8:33:00 PM, dean <dean_at_chillipepper.com> wrote regarding help with read-only user :

> please forgive me for intruding but i have a problem.
 

> my company assigned me the task to migrate our oracle database
> from unix to nt. i used the oracle wizard to give me skeleton
> creation script. i create a couple tablespaces with an account
> to handle tables.
 

> a new requirement is to now have a read only user/account into
> one of the table spaces, such that some off-the-shelf product
> (like crystal reports) can retrive data and generate reports.
 

> i'm having problems creating the read-only user.
 

> i've attached the script segment that creates my users.
 

> any help, pointers would be greatly appreciated.
 

> thank you for any time you give me.
 

> dean

> grant connect,dba,resource to MyDBA identified by ABC3DEF;
> alter user MyDBA default tablespace work ts
> temporary tablespace work ts;
 

> grant connect,resource to MyMainUser identified by main3password;
> alter user impresa default tablespace activity ts
> temporary tablespace activity ts;

> grant execute any procedure, javasyspriv to MyMainUser identified by
> main3password;
> grant create any trigger, alter any trigger to MyMainUser
> identified by main3password;
 

> grant connect to reader identified by reader;
> alter user reader default tablespace activity ts
> temporary tablespace activity ts;
Received on Tue Apr 11 2000 - 00:00:00 CDT