4.2 Minimum database user permissions

Oracle

CREATE SESSION

CREATE TABLE

CREATE VIEW

CREATE SEQUENCE

UNLIMITED TABLE SPACE

CREATE SESSION

UNLIMITED TABLE SPACE (only needed if you do not configure user quotas)

CREATE TABLE

MySQL

SELECT

INSERT

UPDATE

DELETE

CREATE

DROP

REFERENCES

INDEX

ALTER

CREATE_TEMP_TABLE

LOCK_TABLES

SELECT

INSERT

UPDATE

DELETE

SQL Server - DB level

Create Table

Create View

Connect

Connect

SQL Server - Schema level

Alter

Insert

References

Select

Update

Delete

Insert

Select

Update

Delete

DB2

See 4.5.1 DB2 user account for a complete description.

See 4.5.1 DB2 user account for a complete description.