Techniques are provided for facilitating uniform access control to data
managed by a database server that can emulate hierarchically organized systems,
whether the data is accessed through hierarchical or relational access mechanisms.
A database server that can emulate hierarchically organized systems uses separate
relational or object-relational database tables to store the content of the resources
that belong to a hierarchy (the "content structures") and information that captures
the hierarchy (the "hierarchy structures"). Both types of structures contain access
control data that define consistent user access privileges. To determine access
privileges for a user requesting access to data in the database, access control
information is accessed in the hierarchy structures when the request is made through
the hierarchical access mechanism, or accessed in the content structures when the
request is made through a relational access mechanism. Access control is consistent
between the hierarchical or relational access mechanisms because access through
either is governed by user access data that reflects the same privileges.