0

I am trying to give schema permissions on all tables in a single instance.

For example, I am in Schema A, and I need to access the tables in Schema A from Schema B.

I tried to grant select on A. * to B and I am getting an invalid table name.

Any idea why I'm getting this error?

grizzthedj
  • 7,131
  • 16
  • 42
  • 62
Pranay Kumar
  • 78
  • 10

1 Answers1

1

Afaik, there's not a direct way to do this. The easiest shortcut I know is to run something like 

select 'grant select on A.' || table_name || ' to B;'
from user_tables;

And then copy/paste the results and run that.

kfinity
  • 8,581
  • 1
  • 13
  • 20