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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.