For the Relational Engine, security is either turned on or off (see Note above). By default, security is turned off. Security is turned on by suppling a password for the Master user.
In SQL Engine Reference, the following content applies to security for the Relational Engine:
For complete information on making a transition from Classic to Mixed or Database security, see Security Tasks in
PSQL User's Guide. The next topic provides a brief overview of the material covered in the user’s guide.
PCC currently does not provide a way to set an owner name in the security properties of a file. However, you can use a GRANT statement in PCC SQL Editor to supply an owner name, as described under Owner Names in
SQL Engine Reference. You can also set or clear an owner name on a file with the Maintenance utility or the Function Executor tool. See
Managing Owner Names under documentation for the Maintenance utility for more details about the uses of owner names.