1) if 10 tables is many, I hope you'll never face a real DB !!
2) just do :
select 'grant select on ' || table_name || ' to user2;'
from dba_tables
where owner = 'user1'
|
Results 1 to 10 of 12
Thread: Assinging 'Select' previliges.Threaded View
|
Click Here to Expand Forum to Full Width |