How to dynamically update oracle role using trigger
How to dynamically update oracle role using trigger:
i have schema owner svmanger in the database. there are five tables owned by svmanager.
Table A, B, C, D, E.
I have a role which is read only to these tables under this schema: SVMANAGER_READ_ONLY
now if i create a new table F under svmanager. the role SVMANAGER_READ_ONLY does not gets updated, so user have this role assigned can not access table F.
is there a way to create trigger to update this role dynamically anytime a table is created or dropped?
thanks.