I use the below , it works to grant select permission to amy on table1 .
grant select db_name.table1 to amy ;
However , the below is not work.
grant select db_name.* to amy ;
the error is as below .
ORA-: invalid table name
Would advise what is wrong in my command , what I want is grant select to amy on ALL table .
thanks