grants gives - Search results in mailing lists

2024-01-28 17:11:18 | Re: CREATE ROLE inheritance details (David G. Johnston)

giving them the right to grant membership in this role - to others. + The ADMIN clause

2024-01-24 19:04:48 | Re: SQL command : ALTER DATABASE OWNER TO (David G. Johnston)

grants to be established. If I give out the ability via a grant option only

2020-09-10 15:27:03 | dblink_connect grant privelages on foreign db table (PG Doc comments form)

GRANT SELECT seemingly attempts to give a local user permissions on a table in a foreign

2019-11-14 22:29:44 | no mention of GRANT USAGE in postgres_fdw docs (PG Doc comments form)

gives a nice step by step on what's needed to configure a FOREIGN SERVER. However, one crucial step is missed, and that is that you need to issue GRANT

2018-02-23 12:41:27 | pg_hba_file_rules permission issue (PG Doc comments form)

granted select privileges. But for the privileged user it's giving following error while trying

2015-07-14 03:24:59 | Clarification for schema and schema object privileges (Ian Barwick)

grant privileges on objects in a particular schema to a user other than the schema owner, giving

2011-03-11 15:48:10 | backward compatible (Bruce Momjian)

giving all roles ! the INHERIT attribute, for backwards compatibility with pre-8.1 releases in which users always had use of permissions granted

2010-08-16 11:00:13 | Re: Ambiguous index entry for Privileges (Kevin Grittner)

GRANT and REVOKE to change privileges, it should give an overview of privileges and discuss

2009-11-17 15:26:06 | Postgresql Database Lock Problem (shohorab hossain)

granted ---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+-----------+--------- transactionid | | | | | | 18386574 | | | | 24/1586 | 19181 | ShareLock | f (1 row) *** Here you can see that process 19196 have ExclusiveLock on transaction 18386574 and process 19181 is waiting for ShareLock to the same transaction. When I monitor

2005-01-31 21:20:14 | Re: doc change request (7.4.6, reference section, grant) (Peter Eisentraut)

gives a basic idea of what each privilege is for and explicitly states that details are to be found on the reference page of each command. Note that the "basic ideas" are fairly static

2002-05-14 13:01:46 | COPY access rights (Bruno Wolff III)

GRANT the INSERT description says it gives access to COPY FROM, but the UPDATE description

2000-10-30 06:36:50 | question regarding grant privilege (Mercy)

gives explanation on grant privilge that it could be extended to 1. Tables 2. Views