Inherit Database - Table Permissions
Hi Team,
We have a database and keep creating new tables for the requirement.
Every time we have to grant readonly permission to the new tables which are
created for the db user. Instead is there a way to inherit privileges.
Basically, we have a readonly user, who should run only select statements
on existing or nee tables.
Can you help me on how to achieve it.
On 5/31/19 11:17 AM, Sathish Kumar wrote:
Hi Team,
We have a database and keep creating new tables for the requirement.
Every time we have to grant readonly permission to the new tables which
are created for the db user. Instead is there a way to inherit privileges.
Basically, we have a readonly user, who should run only select statements
on existing or nee tables.Can you help me on how to achieve it.
Maybe granting default privileges is what you need.
--
Angular momentum makes the world go 'round.