OnDoc
| sign
in
up
~
pub
|
pdf
txt
html
toc
url
|
<<
>>
1
~
8
9
10
11
12
13
14
15
Table of Contents
Managing rights in PostgreSQL
1 The author
2 Introduction
3 Users, groups and roles
3.1 Users and groups
3.2 Modifying a role
4 Special roles and role attributes
4.1 Superusers
4.2 The PUBLIC role
4.3 Attributes
4.4 Inheritance
4.5 Inheritance example
5 Default rights
6 How access is granted or denied
6.1 Host Based Access
6.2 Database connection attribute
6.3 The object hierarchy
6.4 Going through to a relation
6.5 Ownership
6.6 Special cases
6.7 Viewing rights
6.8 Granting and Revoking rigths
6.9 Securing the default installation
7 Default privilages
7.1 How default privileges work
7.2 The read only user
7.3 Other use cases
8 SE-PostgreSQL?
8.1 Prerequisites
8.2 Installation
8.3 Creating your policy
8.4 Current limitations
9 Conclusion