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.