Managing Users

 

DBMaker supports multiple users and allows database privileges to be granted or revoked to those users. JDBA tool provides an easy to use interface for creating new users, changing user passwords, and adding or revoking user privileges. User names have a maximum length of thirty-two characters, passwords have a maximum length of sixteen characters, and both may contain letters, numbers, the underscore character, and the symbols $ and #. The first character may not be a number. You must be logged onto the database as SYSADM to be able to create a new user or change database authority for any user. Object privileges include the SELECT, INSERT, DELETE, UPDATE, INDEX, ALTER, and REFERENCE privileges for tables and views, and the EXECUTE privilege for stored commands and stored procedures. Object privileges may be granted or revoked by the user that created the object, or by a user with DBA authority or higher.


Related topic:

Creating a New User Account
Changing Security Level

Changing a User's Password

Deleting a User Account