Skip to Main Content

How to dynamically update oracle role using trigger

marlborocatAug 17 2011 — edited Aug 18 2011
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?

Post Details
Added on Aug 17 2011