Re: [GENERAL] function to grant select on all tables in several schemas

2010-01-20 Thread Gerd Koenig
Hello Andreas, thanks for your support, perfect :-) regardsGERD On Wednesday 20 January 2010 4:59:57 pm Andreas Kretschmer wrote: > Gerd Koenig wrote: > > Hello, > > > > I'm looking for a solution to grant select to a group to have "read-only" > > group across all tables/views/.. in sev

Re: [GENERAL] function to grant select on all tables in several schemas

2010-01-20 Thread Andreas Kretschmer
Gerd Koenig wrote: > Hello, > > I'm looking for a solution to grant select to a group to have "read-only" > group across all tables/views/.. in several schemas. I already found some > workarounds and I decided to create a function to cover this topic. > But calling this function throws the err

Re: [GENERAL] function to grant select on all tables in several schemas

2010-01-20 Thread Pavel Stehule
Hello I am not sure, but maybe .. you are doesn't use correct quotes: you use ´´, but you have to use '' Regards Pavel Stehule 2010/1/20 Gerd Koenig : > Hello, > > I'm looking for a solution to grant select to a group to have "read-only" > group across all tables/views/.. in several schemas. I

[GENERAL] function to grant select on all tables in several schemas

2010-01-20 Thread Gerd Koenig
Hello, I'm looking for a solution to grant select to a group to have "read-only" group across all tables/views/.. in several schemas. I already found some workarounds and I decided to create a function to cover this topic. But calling this function throws the error: "" ERROR: column "´r´" does