1 /*------------------------------------------------------------------------- 2 * 3 * acl.h 4 * Definition of (and support for) access control list data structures. 5 * 6 * 7 * Portions Copyright (c) 1996-2016, PostgreSQL Global Development Group 8 * Portions Copyright (c) 1994, Regents of the University of California 9 * 10 * src/include/utils/acl.h 11 * 12 * NOTES 13 * An ACL array is simply an array of AclItems, representing the union 14 * of the privileges represented by the individual items. A zero-length 15 * array represents "no privileges". 16 * 17 * The order of items in the array is important as client utilities (in 18 * particular, pg_dump, though possibly other clients) expect to be able 19 * to issue GRANTs in the ordering of the items in the array. The reason 20 * this matters is that GRANTs WITH GRANT OPTION must be before any GRANTs 21 * which depend on it. This happens naturally in the backend during 22 * operations as we update ACLs in-place, new items are appended, and 23 * existing entries are only removed if there's no dependency on them (no 24 * GRANT can been based on it, or, if there was, those GRANTs are also 25 * removed). 26 * 27 * For backward-compatibility purposes we have to allow null ACL entries 28 * in system catalogs. A null ACL will be treated as meaning "default 29 * protection" (i.e., whatever acldefault() returns). 30 *------------------------------------------------------------------------- 31 */ 32 #ifndef ACL_H 33 #define ACL_H 34 35 #include "access/htup.h" 36 #include "nodes/parsenodes.h" 37 #include "utils/array.h" 38 #include "utils/snapshot.h" 39 40 41 /* 42 * typedef AclMode is declared in parsenodes.h, also the individual privilege 43 * bit meanings are defined there 44 */ 45 46 #define ACL_ID_PUBLIC 0 /* placeholder for id in a PUBLIC acl item */ 47 48 /* 49 * AclItem 50 * 51 * Note: must be same size on all platforms, because the size is hardcoded 52 * in the pg_type.h entry for aclitem. 53 */ 54 typedef struct AclItem 55 { 56 Oid ai_grantee; /* ID that this item grants privs to */ 57 Oid ai_grantor; /* grantor of privs */ 58 AclMode ai_privs; /* privilege bits */ 59 } AclItem; 60 61 /* 62 * The upper 16 bits of the ai_privs field of an AclItem are the grant option 63 * bits, and the lower 16 bits are the actual privileges. We use "rights" 64 * to mean the combined grant option and privilege bits fields. 65 */ 66 #define ACLITEM_GET_PRIVS(item) ((item).ai_privs & 0xFFFF) 67 #define ACLITEM_GET_GOPTIONS(item) (((item).ai_privs >> 16) & 0xFFFF) 68 #define ACLITEM_GET_RIGHTS(item) ((item).ai_privs) 69 70 #define ACL_GRANT_OPTION_FOR(privs) (((AclMode) (privs) & 0xFFFF) << 16) 71 #define ACL_OPTION_TO_PRIVS(privs) (((AclMode) (privs) >> 16) & 0xFFFF) 72 73 #define ACLITEM_SET_PRIVS(item,privs) \ 74 ((item).ai_privs = ((item).ai_privs & ~((AclMode) 0xFFFF)) | \ 75 ((AclMode) (privs) & 0xFFFF)) 76 #define ACLITEM_SET_GOPTIONS(item,goptions) \ 77 ((item).ai_privs = ((item).ai_privs & ~(((AclMode) 0xFFFF) << 16)) | \ 78 (((AclMode) (goptions) & 0xFFFF) << 16)) 79 #define ACLITEM_SET_RIGHTS(item,rights) \ 80 ((item).ai_privs = (AclMode) (rights)) 81 82 #define ACLITEM_SET_PRIVS_GOPTIONS(item,privs,goptions) \ 83 ((item).ai_privs = ((AclMode) (privs) & 0xFFFF) | \ 84 (((AclMode) (goptions) & 0xFFFF) << 16)) 85 86 87 #define ACLITEM_ALL_PRIV_BITS ((AclMode) 0xFFFF) 88 #define ACLITEM_ALL_GOPTION_BITS ((AclMode) 0xFFFF << 16) 89 90 /* 91 * Definitions for convenient access to Acl (array of AclItem). 92 * These are standard PostgreSQL arrays, but are restricted to have one 93 * dimension and no nulls. We also ignore the lower bound when reading, 94 * and set it to one when writing. 95 * 96 * CAUTION: as of PostgreSQL 7.1, these arrays are toastable (just like all 97 * other array types). Therefore, be careful to detoast them with the 98 * macros provided, unless you know for certain that a particular array 99 * can't have been toasted. 100 */ 101 102 103 /* 104 * Acl a one-dimensional array of AclItem 105 */ 106 typedef ArrayType Acl; 107 108 #define ACL_NUM(ACL) (ARR_DIMS(ACL)[0]) 109 #define ACL_DAT(ACL) ((AclItem *) ARR_DATA_PTR(ACL)) 110 #define ACL_N_SIZE(N) (ARR_OVERHEAD_NONULLS(1) + ((N) * sizeof(AclItem))) 111 #define ACL_SIZE(ACL) ARR_SIZE(ACL) 112 113 /* 114 * fmgr macros for these types 115 */ 116 #define DatumGetAclItemP(X) ((AclItem *) DatumGetPointer(X)) 117 #define PG_GETARG_ACLITEM_P(n) DatumGetAclItemP(PG_GETARG_DATUM(n)) 118 #define PG_RETURN_ACLITEM_P(x) PG_RETURN_POINTER(x) 119 120 #define DatumGetAclP(X) ((Acl *) PG_DETOAST_DATUM(X)) 121 #define DatumGetAclPCopy(X) ((Acl *) PG_DETOAST_DATUM_COPY(X)) 122 #define PG_GETARG_ACL_P(n) DatumGetAclP(PG_GETARG_DATUM(n)) 123 #define PG_GETARG_ACL_P_COPY(n) DatumGetAclPCopy(PG_GETARG_DATUM(n)) 124 #define PG_RETURN_ACL_P(x) PG_RETURN_POINTER(x) 125 126 /* 127 * ACL modification opcodes for aclupdate 128 */ 129 #define ACL_MODECHG_ADD 1 130 #define ACL_MODECHG_DEL 2 131 #define ACL_MODECHG_EQL 3 132 133 /* 134 * External representations of the privilege bits --- aclitemin/aclitemout 135 * represent each possible privilege bit with a distinct 1-character code 136 */ 137 #define ACL_INSERT_CHR 'a' /* formerly known as "append" */ 138 #define ACL_SELECT_CHR 'r' /* formerly known as "read" */ 139 #define ACL_UPDATE_CHR 'w' /* formerly known as "write" */ 140 #define ACL_DELETE_CHR 'd' 141 #define ACL_TRUNCATE_CHR 'D' /* super-delete, as it were */ 142 #define ACL_REFERENCES_CHR 'x' 143 #define ACL_TRIGGER_CHR 't' 144 #define ACL_EXECUTE_CHR 'X' 145 #define ACL_USAGE_CHR 'U' 146 #define ACL_CREATE_CHR 'C' 147 #define ACL_CREATE_TEMP_CHR 'T' 148 #define ACL_CONNECT_CHR 'c' 149 150 /* string holding all privilege code chars, in order by bitmask position */ 151 #define ACL_ALL_RIGHTS_STR "arwdDxtXUCTc" 152 153 /* 154 * Bitmasks defining "all rights" for each supported object type 155 */ 156 #define ACL_ALL_RIGHTS_COLUMN (ACL_INSERT|ACL_SELECT|ACL_UPDATE|ACL_REFERENCES) 157 #define ACL_ALL_RIGHTS_RELATION (ACL_INSERT|ACL_SELECT|ACL_UPDATE|ACL_DELETE|ACL_TRUNCATE|ACL_REFERENCES|ACL_TRIGGER) 158 #define ACL_ALL_RIGHTS_SEQUENCE (ACL_USAGE|ACL_SELECT|ACL_UPDATE) 159 #define ACL_ALL_RIGHTS_DATABASE (ACL_CREATE|ACL_CREATE_TEMP|ACL_CONNECT) 160 #define ACL_ALL_RIGHTS_FDW (ACL_USAGE) 161 #define ACL_ALL_RIGHTS_FOREIGN_SERVER (ACL_USAGE) 162 #define ACL_ALL_RIGHTS_FUNCTION (ACL_EXECUTE) 163 #define ACL_ALL_RIGHTS_LANGUAGE (ACL_USAGE) 164 #define ACL_ALL_RIGHTS_LARGEOBJECT (ACL_SELECT|ACL_UPDATE) 165 #define ACL_ALL_RIGHTS_NAMESPACE (ACL_USAGE|ACL_CREATE) 166 #define ACL_ALL_RIGHTS_TABLESPACE (ACL_CREATE) 167 #define ACL_ALL_RIGHTS_TYPE (ACL_USAGE) 168 169 /* operation codes for pg_*_aclmask */ 170 typedef enum 171 { 172 ACLMASK_ALL, /* normal case: compute all bits */ 173 ACLMASK_ANY /* return when result is known nonzero */ 174 } AclMaskHow; 175 176 /* result codes for pg_*_aclcheck */ 177 typedef enum 178 { 179 ACLCHECK_OK = 0, 180 ACLCHECK_NO_PRIV, 181 ACLCHECK_NOT_OWNER 182 } AclResult; 183 184 /* this enum covers all object types that can have privilege errors */ 185 /* currently it's only used to tell aclcheck_error what to say */ 186 typedef enum AclObjectKind 187 { 188 ACL_KIND_COLUMN, /* pg_attribute */ 189 ACL_KIND_CLASS, /* pg_class */ 190 ACL_KIND_SEQUENCE, /* pg_sequence */ 191 ACL_KIND_DATABASE, /* pg_database */ 192 ACL_KIND_PROC, /* pg_proc */ 193 ACL_KIND_OPER, /* pg_operator */ 194 ACL_KIND_TYPE, /* pg_type */ 195 ACL_KIND_LANGUAGE, /* pg_language */ 196 ACL_KIND_LARGEOBJECT, /* pg_largeobject */ 197 ACL_KIND_NAMESPACE, /* pg_namespace */ 198 ACL_KIND_OPCLASS, /* pg_opclass */ 199 ACL_KIND_OPFAMILY, /* pg_opfamily */ 200 ACL_KIND_COLLATION, /* pg_collation */ 201 ACL_KIND_CONVERSION, /* pg_conversion */ 202 ACL_KIND_TABLESPACE, /* pg_tablespace */ 203 ACL_KIND_TSDICTIONARY, /* pg_ts_dict */ 204 ACL_KIND_TSCONFIGURATION, /* pg_ts_config */ 205 ACL_KIND_FDW, /* pg_foreign_data_wrapper */ 206 ACL_KIND_FOREIGN_SERVER, /* pg_foreign_server */ 207 ACL_KIND_EVENT_TRIGGER, /* pg_event_trigger */ 208 ACL_KIND_EXTENSION, /* pg_extension */ 209 MAX_ACL_KIND /* MUST BE LAST */ 210 } AclObjectKind; 211 212 213 /* 214 * routines used internally 215 */ 216 extern Acl *acldefault(GrantObjectType objtype, Oid ownerId); 217 extern Acl *get_user_default_acl(GrantObjectType objtype, Oid ownerId, 218 Oid nsp_oid); 219 extern void recordDependencyOnNewAcl(Oid classId, Oid objectId, int32 objsubId, 220 Oid ownerId, Acl *acl); 221 222 extern Acl *aclupdate(const Acl *old_acl, const AclItem *mod_aip, 223 int modechg, Oid ownerId, DropBehavior behavior); 224 extern Acl *aclnewowner(const Acl *old_acl, Oid oldOwnerId, Oid newOwnerId); 225 extern Acl *make_empty_acl(void); 226 extern Acl *aclcopy(const Acl *orig_acl); 227 extern Acl *aclconcat(const Acl *left_acl, const Acl *right_acl); 228 extern Acl *aclmerge(const Acl *left_acl, const Acl *right_acl, Oid ownerId); 229 extern void aclitemsort(Acl *acl); 230 extern bool aclequal(const Acl *left_acl, const Acl *right_acl); 231 232 extern AclMode aclmask(const Acl *acl, Oid roleid, Oid ownerId, 233 AclMode mask, AclMaskHow how); 234 extern int aclmembers(const Acl *acl, Oid **roleids); 235 236 extern bool has_privs_of_role(Oid member, Oid role); 237 extern bool is_member_of_role(Oid member, Oid role); 238 extern bool is_member_of_role_nosuper(Oid member, Oid role); 239 extern bool is_admin_of_role(Oid member, Oid role); 240 extern void check_is_member_of_role(Oid member, Oid role); 241 extern Oid get_role_oid(const char *rolename, bool missing_ok); 242 extern Oid get_role_oid_or_public(const char *rolename); 243 extern Oid get_rolespec_oid(const Node *node, bool missing_ok); 244 extern void check_rolespec_name(const Node *node, const char *detail_msg); 245 extern HeapTuple get_rolespec_tuple(const Node *node); 246 extern char *get_rolespec_name(const Node *node); 247 248 extern void select_best_grantor(Oid roleId, AclMode privileges, 249 const Acl *acl, Oid ownerId, 250 Oid *grantorId, AclMode *grantOptions); 251 252 extern void initialize_acl(void); 253 254 /* 255 * SQL functions (from acl.c) 256 */ 257 extern Datum aclitemin(PG_FUNCTION_ARGS); 258 extern Datum aclitemout(PG_FUNCTION_ARGS); 259 extern Datum aclinsert(PG_FUNCTION_ARGS); 260 extern Datum aclremove(PG_FUNCTION_ARGS); 261 extern Datum aclcontains(PG_FUNCTION_ARGS); 262 extern Datum makeaclitem(PG_FUNCTION_ARGS); 263 extern Datum aclitem_eq(PG_FUNCTION_ARGS); 264 extern Datum hash_aclitem(PG_FUNCTION_ARGS); 265 extern Datum acldefault_sql(PG_FUNCTION_ARGS); 266 extern Datum aclexplode(PG_FUNCTION_ARGS); 267 268 /* 269 * prototypes for functions in aclchk.c 270 */ 271 extern void ExecuteGrantStmt(GrantStmt *stmt); 272 extern void ExecAlterDefaultPrivilegesStmt(AlterDefaultPrivilegesStmt *stmt); 273 274 extern void RemoveRoleFromObjectACL(Oid roleid, Oid classid, Oid objid); 275 extern void RemoveDefaultACLById(Oid defaclOid); 276 277 extern AclMode pg_attribute_aclmask(Oid table_oid, AttrNumber attnum, 278 Oid roleid, AclMode mask, AclMaskHow how); 279 extern AclMode pg_class_aclmask(Oid table_oid, Oid roleid, 280 AclMode mask, AclMaskHow how); 281 extern AclMode pg_database_aclmask(Oid db_oid, Oid roleid, 282 AclMode mask, AclMaskHow how); 283 extern AclMode pg_proc_aclmask(Oid proc_oid, Oid roleid, 284 AclMode mask, AclMaskHow how); 285 extern AclMode pg_language_aclmask(Oid lang_oid, Oid roleid, 286 AclMode mask, AclMaskHow how); 287 extern AclMode pg_largeobject_aclmask_snapshot(Oid lobj_oid, Oid roleid, 288 AclMode mask, AclMaskHow how, Snapshot snapshot); 289 extern AclMode pg_namespace_aclmask(Oid nsp_oid, Oid roleid, 290 AclMode mask, AclMaskHow how); 291 extern AclMode pg_tablespace_aclmask(Oid spc_oid, Oid roleid, 292 AclMode mask, AclMaskHow how); 293 extern AclMode pg_foreign_data_wrapper_aclmask(Oid fdw_oid, Oid roleid, 294 AclMode mask, AclMaskHow how); 295 extern AclMode pg_foreign_server_aclmask(Oid srv_oid, Oid roleid, 296 AclMode mask, AclMaskHow how); 297 extern AclMode pg_type_aclmask(Oid type_oid, Oid roleid, 298 AclMode mask, AclMaskHow how); 299 300 extern AclResult pg_attribute_aclcheck(Oid table_oid, AttrNumber attnum, 301 Oid roleid, AclMode mode); 302 extern AclResult pg_attribute_aclcheck_all(Oid table_oid, Oid roleid, 303 AclMode mode, AclMaskHow how); 304 extern AclResult pg_class_aclcheck(Oid table_oid, Oid roleid, AclMode mode); 305 extern AclResult pg_database_aclcheck(Oid db_oid, Oid roleid, AclMode mode); 306 extern AclResult pg_proc_aclcheck(Oid proc_oid, Oid roleid, AclMode mode); 307 extern AclResult pg_language_aclcheck(Oid lang_oid, Oid roleid, AclMode mode); 308 extern AclResult pg_largeobject_aclcheck_snapshot(Oid lang_oid, Oid roleid, 309 AclMode mode, Snapshot snapshot); 310 extern AclResult pg_namespace_aclcheck(Oid nsp_oid, Oid roleid, AclMode mode); 311 extern AclResult pg_tablespace_aclcheck(Oid spc_oid, Oid roleid, AclMode mode); 312 extern AclResult pg_foreign_data_wrapper_aclcheck(Oid fdw_oid, Oid roleid, AclMode mode); 313 extern AclResult pg_foreign_server_aclcheck(Oid srv_oid, Oid roleid, AclMode mode); 314 extern AclResult pg_type_aclcheck(Oid type_oid, Oid roleid, AclMode mode); 315 316 extern void aclcheck_error(AclResult aclerr, AclObjectKind objectkind, 317 const char *objectname); 318 319 extern void aclcheck_error_col(AclResult aclerr, AclObjectKind objectkind, 320 const char *objectname, const char *colname); 321 322 extern void aclcheck_error_type(AclResult aclerr, Oid typeOid); 323 324 extern void recordExtObjInitPriv(Oid objoid, Oid classoid); 325 extern void removeExtObjInitPriv(Oid objoid, Oid classoid); 326 327 328 /* ownercheck routines just return true (owner) or false (not) */ 329 extern bool pg_class_ownercheck(Oid class_oid, Oid roleid); 330 extern bool pg_type_ownercheck(Oid type_oid, Oid roleid); 331 extern bool pg_oper_ownercheck(Oid oper_oid, Oid roleid); 332 extern bool pg_proc_ownercheck(Oid proc_oid, Oid roleid); 333 extern bool pg_language_ownercheck(Oid lan_oid, Oid roleid); 334 extern bool pg_largeobject_ownercheck(Oid lobj_oid, Oid roleid); 335 extern bool pg_namespace_ownercheck(Oid nsp_oid, Oid roleid); 336 extern bool pg_tablespace_ownercheck(Oid spc_oid, Oid roleid); 337 extern bool pg_opclass_ownercheck(Oid opc_oid, Oid roleid); 338 extern bool pg_opfamily_ownercheck(Oid opf_oid, Oid roleid); 339 extern bool pg_database_ownercheck(Oid db_oid, Oid roleid); 340 extern bool pg_collation_ownercheck(Oid coll_oid, Oid roleid); 341 extern bool pg_conversion_ownercheck(Oid conv_oid, Oid roleid); 342 extern bool pg_ts_dict_ownercheck(Oid dict_oid, Oid roleid); 343 extern bool pg_ts_config_ownercheck(Oid cfg_oid, Oid roleid); 344 extern bool pg_foreign_data_wrapper_ownercheck(Oid srv_oid, Oid roleid); 345 extern bool pg_foreign_server_ownercheck(Oid srv_oid, Oid roleid); 346 extern bool pg_event_trigger_ownercheck(Oid et_oid, Oid roleid); 347 extern bool pg_extension_ownercheck(Oid ext_oid, Oid roleid); 348 extern bool has_createrole_privilege(Oid roleid); 349 extern bool has_bypassrls_privilege(Oid roleid); 350 351 #endif /* ACL_H */ 352