Thread: Inherit Database - Table Permissions

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.