Re: How do I Grant a user access to another schema rather than simply an object in that schema

"Mark" <mzquincey_at_hotmail.com> wrote in message news:_5zC8.165$Ok7.4281517_at_newssvr17.news.prodigy.com...
> How do I Grant a user access to another schema rather than simply an
object
> such as a table in the other schema?
>
>
>

That is not possible.
The only other option is grant select any table, but in that case you will basically drop security.

Granting privilege is also a relatively one-time operation, and if you grant privilege to a role and the role to an user, I don't see your concern of having to do too much work.
Also you can quite easily
select 'grant select on '||table_name||' to <role>' from user_tables, etc.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Regards


--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address