|
Security is a database property that requires a user to provide a user name and password to access the database. By default, database security is turned off.
Database security can be turned on through PCC or by executing an SQL statement. Once enabled, you may create groups and users and assign permissions to them. Permissions can include database rights, table rights, and column rights within tables.
See Security Tasks in Advanced Operations Guide for how to turn on security, create groups, users, and set permissions.
Note
All database connections but one must be closed when security is turned on or off. The Master user must have only one connection open and must be the only user connected.
|
Chapter contents
Prev topic: Triggers, Stored Procedures, User-defined Functions, and Views
|