Hi,
I want to grant only the connect, select, insert, update privileges on
all the tables of a schema to a particular user/group
Initially, i had revoked all the privileges from public.
It seems that the privileges Select, Insert, Update can be given only
on a table level and not on the schema level.
I can iterate and get the script for the select privileges for all the
tables and execute it.
However, if the admin user creates the table in that schema, i will
need to grant the select, insert, update privs for newly created table
to the user again.
Is there some other way to realize that(like giving select, insert,
update privs on all the tables of that schema)
Rahul