Re: Role/Privilege and remote databases

Dereck L. Dietz wrote:
> Oracle 10.2.0.3, Windows 2003 Server
>
> Below is the scenario. I'm confused about roles and permissions when using
> more than just a local database. Is the question at the end of the scenario
> correct?
>
> remote_server
>
> my_schema.my_table
> - GRANT SELECT, INSERT, UPDATE ON my_schema.my_table TO MY_ROLE
>
> my_role
> - user1
> - user2
>
> local server
>
> CREATE PUBLIC SYNONYM my_table FOR my_schema.my_table_at_remote_server
>
> my_role
> - user3
>
> Q: Is having the MY_ROLE role on both the remote and local server, and
> granting privileges
> to the role sufficient to allow USER3 to access the MY_TABLE on the
> remote server?

What prevents you from running

SELECT COUNT(*)
FROM user_tables_at_remote;

and finding out? This is an interview question? a test?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org