Re: Rolls

2018-02-01 Thread David G. Johnston
On Thursday, February 1, 2018, Andrew Bartley wrote: > Hi all, > > I am trying to work out a way to create a roll/user that can only execute > one particular function and nothing else. The particular function has been > created with "SECURITY DEFINER". > Never tried it but "REVOKE PUBLIC FROM r

Re: Rolls

2018-02-01 Thread Andrew Bartley
Sorry Roles On Fri, 2 Feb 2018 at 08:29 Rob Sargent wrote: > > > On 02/01/2018 02:22 PM, Andrew Bartley wrote: > > Hi all, > > > > I am trying to work out a way to create a roll/user that can only > > execute one particular function and nothing else. The particular > > function has been cre

Re: Rolls

2018-02-01 Thread Rob Sargent
On 02/01/2018 02:22 PM, Andrew Bartley wrote: Hi all, I am trying to work out a way to create a roll/user that can only execute one particular function and nothing else. The particular function has been created with "SECURITY DEFINER". Regards Andrew Bartley And I thought you we offeri