grants files - Search results in mailing lists
Mailing lists >> pgsql-admin >> Thread
2025-02-25 02:54:33 | Re: Changing the Datatype from Bit to Boolean. (Mark Smith)
file.backup Solution: Make sure the user you're logged in as has the appropriate permissions to create objects in the database. ==>GRANT
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-10-15 19:00:26 | Re: create foreign table (vignesh kumar)
granting access to use the postgres_fdw.. then try accessing it.. that's the optimal way.. I'm not getting what is being tried here
Sent from Outlook for Android
Mailing lists >> pgsql-admin >> Thread
2024-07-26 17:03:53 | Re: pg_restore but for full user and roles, etc (Keith Fiske)
file that you then use "psql -f" to restore. And to clarify, while the roles themselves are global, the GRANTS
Mailing lists >> pgsql-admin >> Thread
2024-07-17 13:24:04 | Error; pg_upgrade 10 to 15 (SOzcn)
GRANT SELECT ON TABLE "pg_catalog"."pg_pltemplate" TO "username";* We upgraded many Postgresql in the same way. But this error just blew up somehow. For this cluster, we upgraded 10 to 11 and then
Mailing lists >> pgsql-admin >> Thread >> Search in thread (4)
2024-02-29 02:59:37 | Re: Need help - Unable to grant a role (Siraj G)
files role, hence trying to grant it. Regards Siraj On Thu, Feb 29, 2024 at 7:40 AM David
Mailing lists >> pgsql-admin >> Thread
2023-11-16 17:22:20 | Re: Index file is growing when I drop a table. Why? (Achilleas Mantzios)
Στις 16/11/23 18:32, ο/η Ron Johnson έγραψε: What does pg_locks show ? SELECT
Mailing lists >> pgsql-admin >> Thread >> Search in thread (3)
2023-10-29 01:36:57 | Re: pg_restore -L reordering of the statements does not work (Aditya D)
file with role < > * create table schema1.table1 * grant all on schema1 to user2 * alter table schema1.table1
Mailing lists >> pgsql-admin >> Thread >> Search in thread (3)
2023-10-25 10:01:56 | Re: User/Roles, Owner, and privileges migration strategy (Aditya D)
file the Grants to the *event_tracking.notifications_responses* are coming after the Alter owner
Mailing lists >> pgsql-admin >> Thread >> Search in thread (7)
2023-10-13 06:40:03 | Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than (Zhaoxun Yan)
GRANT EXECUTE ON function pg_catalog.pg_stat_file(text, boolean) TO rewinder; GRANT repmgr
Mailing lists >> pgsql-admin >> Thread
2023-09-26 02:39:26 | pg_rewind: ERROR: could not fetch remote file "global/pg_control": ERROR: permission denied (Zhaoxun Yan)
file Actually I have grant function pg_read_binary_file's execution right to the user
Mailing lists >> pgsql-admin >> Thread
2023-01-24 19:42:58 | pgperms: Declarative / config as code for PostgreSQL permissions (Jille Timmermans)
file describes your desired roles and grants and syncs them to your PostgreSQL cluster. This
Mailing lists >> pgsql-admin >> Thread
2022-11-08 01:19:02 | Re: Allowing users to create objects in version controlled schema (Wells Oliver)
grant privileges as required. All schema definitions tables/views/etc are versioned using git in a structured repository of flat sql files
Mailing lists >> pgsql-admin >> Thread >> Search in thread (3)
2021-06-16 01:45:52 | Re: Dump & restore in directory format and permissions are largely lost? (Tom Lane)
writes: I'd try "pg_restore -s -f - archive.file | grep GRANT" or so. regards, tom lane
Mailing lists >> pgsql-admin >> Thread
2021-01-22 19:36:16 | Re: Create Read only user (Tim Cross)
grant permissions on that schema and its objects without fear of impacting on other users and manage access rights how you see fit. In fact, for more complex applications, I might have multiple schemas
Mailing lists >> pgsql-admin >> Thread
2020-12-25 15:34:22 | ImportError: /usr/lib64/python3.6/site-packages/psycopg2/_psycopg.cpython-36m-x86_64-linux-gnu.so: undefined symbol: PQencryptPasswordConn (Marcelo Miranda)
granted