Re: Grants not working on partitions

On 9/28/24 08:56, Lok P wrote: On Sat, Sep 28, 2024 at 8:46 PM Adrian Klaver > wrote: On 9/28/24 04:02, Lok P wrote: > Hi, > While we are creating any new tables, we used to give SELECT privilege > on the newly created tables using the

Re: Grants not working on partitions

On Sat, Sep 28, 2024 at 8:46 PM Adrian Klaver wrote: > On 9/28/24 04:02, Lok P wrote: > > Hi, > > While we are creating any new tables, we used to give SELECT privilege > > on the newly created tables using the below command. But we are seeing > > now , in case of partitioned tables even if we ha

Re: Grants not working on partitions

On 9/28/24 04:02, Lok P wrote: Hi, While we are creating any new tables, we used to give SELECT privilege on the newly created tables using the below command. But we are seeing now , in case of partitioned tables even if we had given the privileges in the same fashion, the user is not able to