Postgres Pro
Downloads
Home   >   mailing lists

Re: Run function privileges - Mailing list pgadmin-support

From Dave Page
Subject Re: Run function privileges
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8128D63@mail.vale-housing.co.uk
Whole thread Raw
In response to Run function privileges  ("Donald Fraser" <demolish@cwgsy.net>)
List pgadmin-support
Tree view
 
-----Original Message-----
From: Donald Fraser [mailto:demolish@cwgsy.net]
Sent: 12 December 2002 17:53
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Run function privileges

Thanks for that Dave,
you're a STAR when it come to response time. Not use to such fast responses. 
 
Thanks. Luckily I just finished Uni for the holidays so I only need to worry 'bout pgAdmin and the day job at the moment!! 
 
I have another question about functions.
Functions in 7.3 support running with the privileges of the creator (SECURITY DEFINER) this is incredibly useful (no more view work-arounds). My question is having created such a function how do I know what privileges it will be run at? The SQL definition doesn't show the SECURITY DEFINER modifier and I don't see it displayed in any form as part of the properties.

Added for the next snapshot.
 
Regards, Dave.

pgadmin-support by date:

Previous
From: hjohnson
Date:
Subject: For PowerBuilder connect to postgreSQL Q&A
Next
From: "Dave Page"
Date:
Subject: Re: More bugs