Authorization - SAP Documentation

Authorization

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 1542818

Example

SQL Tutorial, Authorization

More Information

SQL Statements: Overview

SQL Reference Manual