grants gives - Search results in mailing lists
Mailing lists >> pgsql-general >> Thread >> Search in thread (2)
2024-11-13 16:40:16 | Re: Fwd: A million users (Alvaro Herrera)
grant all one hundred roles to each of the million users, you would end up with 100_000_000 rows in pg_auth_member). I would expect such a system to work mostly fine
Mailing lists >> pgsql-general >> Thread
2024-10-06 02:37:39 | Re: grant connect to all databases (Matt Zagrabelny)
On Sat, Oct 5, 2024 at 5:43 PM Adrian Klaver
Mailing lists >> pgsql-general >> Thread >> Search in thread (2)
2024-09-28 18:56:05 | Re: Grants not working on partitions (Lok P)
grants from parent to child ,so we can give a call to this function at the end of the pg_partman
Mailing lists >> pgsql-general >> Thread
2024-07-09 03:35:33 | RE: [EXTERNAL] Re: SSPI Feature Request (Buoro, John)
grant access to a user by giving the login name as firstname.lastname@SOMEDOMAIN for example
Mailing lists >> pgsql-general >> Thread
2024-07-08 22:58:00 | Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE (Tom Lane)
grant specificity at all? I follow the use-case of wanting to be able to log into a database where your only useful privileges are locked behind SET requirements. But I'd still argue that
Mailing lists >> pgsql-general >> Thread
2024-06-24 13:14:42 | Re: Execute permission to function (David G. Johnston)
gives the public pseudo-role permission to execute all functions it can see (i.e., schema access permitted). But no, there is no predefined role that enables that function execution. The per-object grant
Mailing lists >> pgsql-general >> Thread
2024-04-16 11:00:09 | Assistance needed for the query execution in non-public schema (Sasmit Utkarsh)
GRANT USAGE, ALTER ON SEQUENCE mqa_flfo_cstr_id_seq TO shc_uadmin; *ERROR: unrecognized privilege type "alter" SQL state: 42601* Is there any other way i can execute the queries, with user *"shc_uadmin
Mailing lists >> pgsql-general >> Thread
2024-04-09 14:59:38 | [MASSMAIL][Code: 0, SQL State: 0A000] when "typing" from pg_catalog (Thiemo Kellner)
gives me [Code: 0, SQL State: 0A000] FEHLER: Verweise auf andere Datenbanken sind nicht implementiert: pg_catalog.pg_roles.rolname Position: 298 [Script position: 334 - 361] To the best of my knowledge, pg_catalog
Mailing lists >> pgsql-general >> Thread
2024-03-28 21:10:09 | [MASSMAIL]Grants and privileges issue (sud)
grant select on schema1.tab1 to ; 2)Additionally , when we are trying to give select privilege
Mailing lists >> pgsql-general >> Thread
2024-02-27 20:40:33 | Aligning grants and privileges (veem v)
Hi, We have two different types of DBA group in current on-premise Oracle databases
Mailing lists >> pgsql-general >> Thread
2024-02-18 10:12:43 | Re: Users and object privileges maintenance (Dominique Devienne)
gives implicit access to the GRANTs of B to A (INHERIT on A), or whether
Mailing lists >> pgsql-general >> Thread
2024-02-02 22:18:19 | update schema table permission denied (Vano Beridze)
granted insert and update permission on the table outbox_event to the user "app" When the following command is run with the user app update adm.outbox_event set .. where id = .. Postgresql gives
Mailing lists >> pgsql-general >> Thread
2023-09-20 20:40:44 | Re: Changed functionality from 14.3 to 15.3 (Erik Wienhold)
granted privileges on 14). 2. The setup script is ok and tests should pass but something is foul on your 15 which results in a false negative (missing privileges on 15). But besides that, tests
Mailing lists >> pgsql-general >> Thread
2023-08-29 11:22:31 | Re: Restoring default privileges on objects (Erik Wienhold)
granting whatever acldefault gives you. Changing the table owner will then also change the grantee
Mailing lists >> pgsql-general >> Thread
2023-07-11 01:28:12 | Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" (Tom Lane)
granting that we had a useful way to enforce such a restriction, figuring out whether to apply it would be subject to race conditions; maybe somebody else is in process of creating an index using