There is a secured table in a DB containing highly confidendial customer data.
We provide users access to the database through roles, which are entirely at database level:
Grant select on DBName to Rolename;
Grant Rolename to Username;
All users should be able to access the data except the data in this table.
Only few selective users should be able to access the data in the secured table.
Is it possible to grant those though a role or otherwise ?
I don't want to map individual tablelevel access to the role (excluding this table) and again provide access through role whenever a new table is added to the database.