Re: Inherit Database - Table Permissions

2019-05-31 Thread Ron
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 reado

Inherit Database - Table Permissions

2019-05-31 Thread Sathish Kumar
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 statement