grants gives - Search results in mailing lists
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-17 13:24:04 | Error; pg_upgrade 10 to 15 (SOzcn)
give any ideas on how to solve this error? Since it is a system table, we cannot intervene on it. *pg_restore: from TOC entry 3312; 0 0 ACL TABLE "pg_pltemplate" postgrespg_restore: error
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-06-10 00:34:49 | Re: GRANT CONNECT ON DATABASE (soroush jurat)
GRANT CONNECT statement allows the role to connect to the database but does not give
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2024-05-05 03:07:38 | Foreign tables - oracle_fdw (Edwin UY)
gives ERROR: permission denied for schema public I have to do GRANT ALL ON SCHEMA
Mailing lists >> pgsql-admin >> Thread
2024-02-29 02:59:37 | Re: Need help - Unable to grant a role (Siraj G)
giving the clarity. It is a GCP environment, we are trying to import using the GCP feature from a backup (export) taken from another instance in the same infra. While the user (hd*****) is created
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)
GRANT EXECUTE ON function pg_read_binary_file(text) TO rep;, and it made no difference. It is not that the user rep does not have the right to execute the function, but that
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2023-09-16 22:46:13 | Re: Completely replacing an old user (Pepe TD Vo)
granted to the user.https:///docs/current/role-removal.html Bach-Nga No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more
Mailing lists >> pgsql-admin >> Thread
2023-06-21 15:57:15 | Re: Why do i need to install set_user extension if i can directly grant (Bhasker Bathini)
giving to individual users. When you know a user or application account need set of permission, you can directly grant
Mailing lists >> pgsql-admin >> Thread
2023-06-20 12:05:53 | Re: Restrict Write Users (Erik Wienhold)
grant additional privileges as necessary give read and/or write access. The user must not be the owner
Mailing lists >> pgsql-admin >> Thread
2021-10-22 02:31:10 | Re: RDS and postgres extension approval (Tom Lane)
give you an untrusted PL, because that's an even shorter path to getting access to the underlying system. The CREATE LANGUAGE man page defines the flag as TRUSTED specifies that the language does
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
Mailing lists >> pgsql-admin >> Thread
2020-11-15 15:46:05 | Create multiple users, to have all privileges on each others objects/relations (otar shavadze)
GRANT ALL PRIVILEGES ON TABLES TO postgres_subuser2; Then I logged in with "postgres_subuser1" and created table "table1". Then I logged in with "postgres_subuser2" and tried: "SELECT COUNT(*) FROM table1". This gives
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2018-08-07 01:46:02 | Re: Re: How to revoke privileged from PostgreSQL's superuser (bejita0409@yahoo.co.jp)
giving a lot of points of view. I know superuser can not be revoked apart of privileges, because it does not like nosuperusers who's privileges can be made from GRANT
Mailing lists >> pgsql-admin >> Thread
2018-03-16 17:52:44 | Re: Connect to db denied for superuser inherited by group (Tom Lane)
granted to "superuserrole". If you did that with the bootstrap superuser, this would include ownership rights on all built-in objects, so it'd still be pretty darn dangerous; but it does not give
Mailing lists >> pgsql-admin >> Thread >> Search in thread (2)
2018-03-14 13:32:18 | RE: Permission issues. Please help (Ricardo Martin Gomez)
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user3;
And just each owner can insert or update
______________________
Saludos
Ing. Ricardo Martín Gomez
DBA - SysAdmin
________________________________
De: Steven Crandell