Schema_2 with grant option solves the problem
Jorge, November 12, 2017 - 12:16 am UTC
Hi,
Thank you, the problem was solved by giving the WITH GRANT OPTION on Schema_2 as you mention.
Thanks.
create view using dblink object
Felipe Dal Pizzol, January 18, 2024 - 8:46 pm UTC
This example is perfect. But if S1 is in another database?
Create a dblink to access is ok, but the grants?
Something like this:
grant select on s1.vw1@mydblink to S2 with grant user;
Can you help me about how could I make this work, please?
Thank you.
January 22, 2024 - 1:55 pm UTC
I'm not sure what you're trying to do here - please clarify.