Any Suggestions on the below scenario will be helpful to us.
# There are 10 tables in a schema =93S1=94 and I have to give select
privilege (Only read access) to a user on all the tables in the schema
=93S1=94.
# Initially I have given the required privileges to the user with
grant command on every table..
# But the problem here is whenever there are new tables building in
the schema =93S1=94, We have to give the privilege Explicitly.
# It is okay if we have less number of tables and the changes are not
frequent, But our case is the tables are changing and there are
hundreds of it.
# Is there any way we to automate whenever a new table is created in
that schema the select privilege should go to user .
Thanks
-Kamal.