Give "select on all tables from a user" to another user [message #666943] |
Sat, 02 December 2017 07:20 |
Rumak18
Messages: 20 Registered: April 2009 Location: Germany
|
Junior Member |
|
|
Hello folks,
i've got a schema user called "LOCAL_01". This user is owner of it's schema. Now there is a need for reading some tables from the schema user LOCAL_01 to another user called "REMOTE_01". Both are created on the same databse. I've tried the following:
Logged in as "LOCAL_01" user:
"GRANT SELECT ON TABLE1 TO REMOTE_01"
"GRANT SELECT ON TABLE2 TO REMOTE_01"
"GRANT SELECT ON TABLE3 TO REMOTE_01"
Logged out as LOCAL_01 , logged in as REMOTE_01. But REMOTE_01 still couldn't read the tables. Reuslt: no tables there.
Am i doing something wrong? How would you do this?
|
|
|