grants gives - Search results in mailing lists
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2020-04-05 08:22:03 | How do CHECK Constraint Function privileges work? (Ruwan Fernando)
grant_test_role"; INSERT INTO app_public.test_tab (id, name) VALUES (1, 'Very Long Name'); COMMIT; My expectation was the INSERT would give
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2018-11-05 13:03:03 | Re: multiple roles for a user ? (Stanton Schmidt)
give multiple roles to the same user? for example : 1. a general role "RoleA" for most users, for "grants
Mailing lists >> pgsql-sql >> Thread
2015-08-25 19:20:54 | Reassign permissions (Amreen Khan)
give grant delete privileges to session_user. And another group of users was granted all privileges
Mailing lists >> pgsql-sql >> Thread
2012-12-28 03:19:18 | Re: strange corruption? (Gavin Flower)
give the table definition . Definitely important: is the exact version of PostgreSQL used, and the operating system. Cheers, Gavin 9.1.6 updated 12.22.2012, openSUSE 12.1 64 bit Linux CREATE TABLE orderseq ( orderseq_id integer NOT NULL
Mailing lists >> pgsql-sql >> Thread
2011-11-15 19:36:43 | Re: pg_dump : problem with grant on table columns (Craig Ringer)
grants were added. Please also give the full, exact text of any error message you get. See the guide
Mailing lists >> pgsql-sql >> Thread
2010-06-10 15:49:02 | Returning to default (e.g. blank) table permissions after a revoke? (Bryce Nesbitt)
gives implicit access to the table owner. But if I touch the grants, then revoke
Mailing lists >> pgsql-sql >> Thread
2008-02-08 10:56:26 | Re: Postgres roles (Pascal Tufenkji)
give permissions such as : GRANT SELECT ON table TO sti_group; GRANT SELECT,INSERT,UPDATE
Mailing lists >> pgsql-sql >> Thread
2007-11-16 12:41:19 | Re: Is there anything special about pg_dump's compression? (Shane Ambler)
GRANT ALL ON SCHEMA REVOKE ALL ON SCHEMA ...... are in your backup files) To test that create a text file with one line - "this is data\n" Then bzip that file - the original uses
Mailing lists >> pgsql-sql >> Thread
2006-11-30 15:42:02 | Grants (Ezequias Rodrigues da Rocha)
give permissions to a table I have: GRANT SELECT, UPDATE, INSERT ON TABLE base.table1 TO administrators
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2006-07-21 12:07:41 | Re: System catalog table privileges (Aaron Bono)
granting access to an untrusted user for reporting purposes... Whenever I have a user that needs to do reporting from any production database, I set up a separate reporting database. If possible, this is placed
Mailing lists >> pgsql-sql >> Thread
2006-07-19 08:24:26 | User Permission (sathish kumar shanmugavelu)
grant only select permission to that user, but now the user could able to create tables. how to restrict this, i want to give
Mailing lists >> pgsql-sql >> Thread
2006-07-04 09:31:44 | Re: i have a problem of privilages (MJ Santhosh)
give permission for a specific user on all objects GRANT ALL on ALL to ; Please
Mailing lists >> pgsql-sql >> Thread
2006-06-27 12:22:50 | Schema management tool (Kyle Bateman)
give me some advice or point me to an article that would help > manage views? I have a view that I use in conjunction with other views, > and since I have to drop
Mailing lists >> pgsql-sql >> Thread
2006-05-03 01:08:09 | Re: grant select on database demo to user (Thusitha Kodikara)
grant information and then run it to give the necessary grants. (The list of tables
Mailing lists >> pgsql-sql >> Thread
2005-10-14 12:53:42 | owner of data type "areas" appears to be invalid ? (george young)
giving the errors like: pg_dump: WARNING: owner of data type "areas" appears to be invalid from pg_dump. This is my production database, (50 users, 18 hours/day, 21MB compressed dump). The output