Show TOC

Background documentationAuthorization

 

There are two types of user authorizations in the SAP MaxDB database system:

  • Authorizations for accessing database objects using SQL statements (database users, database system administrator)

  • Authorizations for carrying out administration tasks such as backups (DBM operators, database system administrator)

Authorizations for Accessing Database Objects Using SQL Statements
SQL Statements for Authorization

CREATE USER Statement

DROP USER Statement

ALTER USER Statement

RENAME USER Statement

GRANT USER Statement

CREATE USERGROUP Statement

DROP USERGROUP Statement

ALTER USERGROUP Statement

RENAME USERGROUP Statement

GRANT USERGROUP Statement

ALTER PASSWORD Statement

CREATE ROLE Statement

DROP ROLE Statement

GRANT Statement

REVOKE Statement
Authorizations for Carrying out Administration Tasks

  • Database Administration, Managing Users

  • Database Administration in CCMS, User Data

  • Database Studio, Managing Users: Overview

  • Database Manager CLI, Managing Database Manager Operators

  • SAP MaxDB Security Guide, User Administration and Authentication, Authorizations

  • SAP note 1542818Information published on SAP site

Example

SQL Tutorial, Authorization

More Information

SQL Statements: Overview

SQL Reference Manual