As detailed in the links provided by Michael, you cannot grant a privilege on an object that does not exist. The proper approach is to create a ROLE, grant the privs to the ROLE, then grant the role to the users. When a new table is created, grant privs on the table to the role as part of the rollout process for the new table.
create role business_user_role;
grant select on app_schema.table_a to business_user_role;
grant select on app_schema.table_b to business_user_role;
--
grant business_user_role to bob;
grant business_user_role to carol;
grant business_user_role to ted;
grant business_user_role to alice;
create table app_schema.table_c
(col_a varchar2(10)
);
grant select on table app_schema.table_c to business_user_role;
] 
Blog
Search
Help
Members
Register
Login
Home
