public inbox for [email protected]  

help / color / mirror / Atom feed

Execute permission to function
2+ messages / 2 participants
[nested] [flat]

* Execute permission to function
@ 2024-06-24 10:29 arun chirappurath <[email protected]>
  2024-06-24 14:44 ` Re: Execute permission to function Adrian Klaver <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: arun chirappurath @ 2024-06-24 10:29 UTC (permalink / raw)
  To: [email protected]

Hi all

I am using rds postgres 14. I have created few users and added them to
pg_readall_data and pg_write_alldata groups


They are able to read all data and do update in tables

However they can't execute functions and not able to script out objects
from pg_admin

Any other role to be added?

Thanks,
Arun


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Execute permission to function
  2024-06-24 10:29 Execute permission to function arun chirappurath <[email protected]>
@ 2024-06-24 14:44 ` Adrian Klaver <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Adrian Klaver @ 2024-06-24 14:44 UTC (permalink / raw)
  To: arun chirappurath <[email protected]>; [email protected]

On 6/24/24 03:29, arun chirappurath wrote:
> Hi all
> 
> I am using rds postgres 14. I have created few users and added them to 
> pg_readall_data and pg_write_alldata groups
> 
> 
> They are able to read all data and do update in tables
> 
> However they can't execute functions and not able to script out objects 
> from pg_admin

The above are two separate issues. Provide examples of what you are 
doing and the errors you get when you do them.

> 
> Any other role to be added?

You probably should take a look at:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Roles.html...

> 
> Thanks,
> Arun

-- 
Adrian Klaver
[email protected]







^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-06-24 14:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-24 10:29 Execute permission to function arun chirappurath <[email protected]>
2024-06-24 14:44 ` Adrian Klaver <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox