I have around 400 tables which belong to a schema lawd. I have created
a role called select_role and want to give only select privileges to that role on all
these tables belonging to lawd.
can i do it with one single command , i tried the security manager but
it does not allow me to select multiple tables and grant the select.
I logged in as lawd and tried the grant select any table to select_role ,
but since lawd is not a dba (i dont want to make it a dba user) this
comes out with insufficient privileges.
How do i do it with a single command or select all tables in one go
at the security manager (tried holding shift+ctrl key , does not work)