user privileges; select any table

From: John Lasta <lasta_at_chello.at>
Date: Tue, 05 Mar 2002 20:05:59 GMT
Message-ID: <Hy9h8.318064$V52.3212540@news.chello.at>

how can an oracle database user make all his tables visible to another user, without granting object privileges, that means without granting every table seperately, e.g.:
"grant select on <table01> to <user>"
"grant select on <table02> to <user>"...

---

e.g.
there are three oracle database users:
- schema01

• schema02
• user03

user03 shall see all tables from schema01 but not those of schema02; in schema01 many tables are created (and deleted) permanently and user03 wants to see them immediately without disturbing schema01 to give him the select privilege.

Any advice would be great !!
lasta Received on Tue Mar 05 2002 - 14:05:59 CST