Hi Stephen,
> On 23. Aug, 2020, at 16:52, Stephen Frost wrote:
>
> If you want has_database_privilege() to return that the user doesn't
> have access due to missing GRANT privileges, yes.
>
> An alternative would be to query against pg_roles and check the
> 'rolcanlogin' privilege/column. Agai
Greetings,
* Paul Förster (paul.foers...@gmail.com) wrote:
> > On 23. Aug, 2020, at 16:28, Stephen Frost wrote:
> >
> > The role attribute system (where you see 'cannot login') is largely
> > independent from the GRANT system (which is what has_database_privilege
> > is checking). Both are requ
Hi Stephen,
> On 23. Aug, 2020, at 16:28, Stephen Frost wrote:
>
> The role attribute system (where you see 'cannot login') is largely
> independent from the GRANT system (which is what has_database_privilege
> is checking). Both are required for a user to log in.
I see. So I need to
postgres
Greetings,
* Paul Förster (paul.foers...@gmail.com) wrote:
> I create a role "test" and it can't (intentionally) login. But why does
> has_database_privilege() return true if "test" can't connect to the cluster
> and can't use any database? Is this a bug or am I doing something strange
> here?
Hi,
I create a role "test" and it can't (intentionally) login. But why does
has_database_privilege() return true if "test" can't connect to the cluster and
can't use any database? Is this a bug or am I doing something strange here? Any
ideas?
I'm on PostgreSQL 12.4.
Cheers,
Paul
postgres=#
ne 23. 8. 2020 v 14:36 odesílatel Mike Martin napsal:
>
> Hi
> I am having difficulty with returning clause and stored procedure. This is
> an (edited) example of where I am
>
> CREATE OR REPLACE PROCEDURE public.arrcopy1(
> dataarr anyarray,
> tblname text,
> cols text DEFAULT NUL
Hi
I am having difficulty with returning clause and stored procedure. This is
an (edited) example of where I am
CREATE OR REPLACE PROCEDURE public.arrcopy1(
dataarr anyarray,
tblname text,
cols text DEFAULT NULL::text,
selstr text DEFAULT NULL::text,
INOUT outarr text[] DE
