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 Mon Apr 10 2000 - 00:00:00 CDT