Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Role/Privilege and remote databases
"Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote in
news:YEWEi.8761$924.1057_at_newssvr23.news.prodigy.net:
> 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?
>
>
It depends upon how/when/where the access to MY_TABLE is made. From SQL*Plus, yes. From PL/SQL, no. Received on Sun Sep 09 2007 - 17:35:58 CDT