summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/privileges.sql
Commit message (Expand)AuthorAgeFilesLines
* Rework pg_input_error_message(), now renamed pg_input_error_info()Michael Paquier2023-02-281-3/+3
* Simplify permissions for LOCK TABLE.Jeff Davis2023-01-131-32/+29
* Convert a few more datatype input functions to report errors softly.Tom Lane2022-12-141-0/+9
* Add grantable MAINTAIN privilege and pg_maintain role.Jeff Davis2022-12-131-57/+64
* Provide non-superuser predefined roles for vacuum and analyzeAndrew Dunstan2022-11-281-0/+24
* Provide per-table permissions for vacuum and analyze.Andrew Dunstan2022-11-281-0/+40
* Fix sloppy cleanup of roles in privileges.sql.Tom Lane2022-11-201-2/+2
* Add a SET option to the GRANT command.Robert Haas2022-11-181-0/+39
* Fix a bug in roles_is_member_of.Robert Haas2022-08-311-0/+25
* Allow grant-level control of role inheritance behavior.Robert Haas2022-08-251-1/+12
* Make role grant system more consistent with other privileges.Robert Haas2022-08-221-3/+39
* Ensure that pg_auth_members.grantor is always valid.Robert Haas2022-08-181-0/+27
* Allow makeaclitem() to accept multiple privilege names.Tom Lane2022-07-031-0/+8
* In REFRESH MATERIALIZED VIEW, set user ID before running user code.Noah Misch2022-05-091-0/+17
* Make relation-enumerating operations be security-restricted operations.Noah Misch2022-05-091-0/+47
* Remove the ability of a role to administer itself.Robert Haas2022-03-281-5/+1
* Add support for MERGE SQL commandAlvaro Herrera2022-03-281-0/+108
* Add test for REVOKE ADMIN OPTIONDaniel Gustafsson2021-11-261-0/+29
* Fix GRANTED BY support in REVOKE ROLE statementsDaniel Gustafsson2021-11-261-0/+8
* Grant memory views to pg_read_all_stats.Jeff Davis2021-10-271-0/+25
* Reduce runtime of privileges.sql test under CLOBBER_CACHE_ALWAYS.Tom Lane2021-05-111-3/+6
* Add pg_read_all_data and pg_write_all_data rolesStephen Frost2021-04-051-0/+25
* Fix has_column_privilege function corner caseJoe Conway2021-03-311-0/+2
* Add "pg_database_owner" default role.Noah Misch2021-03-261-0/+31
* Fix mishandling of column-level SELECT privileges for join aliases.Tom Lane2021-02-081-0/+19
* Fix permission checks on constraint violation errors on partitions.Heikki Linnakangas2021-02-081-0/+38
* Allow GRANTED BY clause in normal GRANT and REVOKE statementsPeter Eisentraut2021-01-301-2/+4
* Add regression test for DROP OWNED BY with default ACLsMichael Paquier2021-01-201-0/+20
* Fix ALTER DEFAULT PRIVILEGES with duplicated objectsMichael Paquier2021-01-201-1/+2
* Invalidate acl.c caches when pg_authid changes.Noah Misch2020-12-251-0/+6
* In security-restricted operations, block enqueue of at-commit user code.Noah Misch2020-11-091-0/+34
* Repair unstable regression test.Tom Lane2020-06-091-1/+2
* Improve ineq_histogram_selectivity's behavior for non-default orderings.Tom Lane2020-06-051-0/+3
* Make inherited LOCK TABLE perform access permission checks on parent table only.Fujii Masao2020-02-181-0/+6
* Make inherited TRUNCATE perform access permission checks on parent table only.Fujii Masao2020-01-311-0/+14
* Use checkAsUser for selectivity estimator checks, if it's set.Dean Rasheed2019-05-061-4/+21
* Un-hide most cascaded-drop details in regression test results.Tom Lane2019-03-241-4/+0
* Remove WITH OIDS support, change oid catalog column visibility.Andres Freund2018-11-201-6/+6
* Fix missing role dependencies for some schema and type ACLs.Tom Lane2018-11-091-0/+9
* Fix spelling errors and typos in commentsMagnus Hagander2018-11-021-1/+1
* Avoid rare race condition in privileges.sql regression test.Tom Lane2018-10-161-0/+1
* Fix corner-case failures in has_foo_privilege() family of functions.Tom Lane2018-10-021-0/+17
* Revert MERGE patchSimon Riggs2018-04-121-108/+0
* MERGE SQL Command following SQL:2016Simon Riggs2018-04-031-0/+108
* Revert "Modified files for MERGE"Simon Riggs2018-04-021-108/+0
* Modified files for MERGESimon Riggs2018-04-021-0/+108
* Clean up duplicate table and function names in regression tests.Tom Lane2018-03-151-113/+113
* Clean up duplicate role and schema names in regression tests.Tom Lane2018-03-151-247/+247
* SQL proceduresPeter Eisentraut2017-11-301-4/+51
* Restrict lo_import()/lo_export() via SQL permissions not hard-wired checks.Tom Lane2017-11-091-0/+2