java.lang.Object
- java.lang.Enum<MySqlObjectPrivilege>
- - com.exasol.dbbuilder.dialects.mysql.MySqlObjectPrivilege

All Implemented Interfaces:

ObjectPrivilege, Serializable, Comparable<MySqlObjectPrivilege>
```
public enum MySqlObjectPrivilege
extends Enum<MySqlObjectPrivilege>
implements ObjectPrivilege
```
MySQL object privilege as used in a GRANT.

See Also:

MySQL documentation

Enum Constant Summary

Enum Constants
Enum Constant	Description
`ALTER`	Alter MY_SQL object privilege.
`ALTER_ROUTINE`	Alter routine MY_SQL object privilege.
`CREATE`	Create MY_SQL object privilege.
`CREATE_ROUTINE`	Create routine MY_SQL object privilege.
`CREATE_TEMPORARY_TABLES`	Create temporary tables MY_SQL object privilege.
`CREATE_VIEW`	Create view MY_SQL object privilege.
`DELETE`	Delete MY_SQL object privilege.
`DROP`	Drop MY_SQL object privilege.
`EVENT`	Event MY_SQL object privilege.
`EXECUTE`	Execute MY_SQL object privilege.
`GRANT_OPTION`	Grant option MY_SQL object privilege.
`INDEX`	Index MY_SQL object privilege.
`INSERT`	Insert MY_SQL object privilege.
`LOCK_TABLES`	Lock tables MY_SQL object privilege.
`REFERENCES`	References MY_SQL object privilege.
`SELECT`	Select MY_SQL object privilege.
`SHOW_VIEW`	Show view MY_SQL object privilege.
`TRIGGER`	Trigger MY_SQL object privilege.
`UPDATE`	Update MY_SQL object privilege.

Method Summary

All Methods Static Methods Instance Methods Abstract Methods Concrete Methods Default Methods
Modifier and Type	Method	Description
`default String`	`getSqlName()`	Get a space-separated name of a privilege.
`String`	`name()`	Get a privilege name as it is.
`static MySqlObjectPrivilege`	`valueOf(String name)`	Returns the enum constant of this type with the specified name.
`static MySqlObjectPrivilege[]`	`values()`	Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

- Enum Constant Detail
  - ALTER
```
public static final MySqlObjectPrivilege ALTER
```
    Alter MY_SQL object privilege.
  - ALTER_ROUTINE
```
public static final MySqlObjectPrivilege ALTER_ROUTINE
```
    Alter routine MY_SQL object privilege.
  - CREATE
```
public static final MySqlObjectPrivilege CREATE
```
    Create MY_SQL object privilege.
  - CREATE_ROUTINE
```
public static final MySqlObjectPrivilege CREATE_ROUTINE
```
    Create routine MY_SQL object privilege.
  - CREATE_TEMPORARY_TABLES
```
public static final MySqlObjectPrivilege CREATE_TEMPORARY_TABLES
```
    Create temporary tables MY_SQL object privilege.
  - CREATE_VIEW
```
public static final MySqlObjectPrivilege CREATE_VIEW
```
    Create view MY_SQL object privilege.
  - DELETE
```
public static final MySqlObjectPrivilege DELETE
```
    Delete MY_SQL object privilege.
  - DROP
```
public static final MySqlObjectPrivilege DROP
```
    Drop MY_SQL object privilege.
  - EVENT
```
public static final MySqlObjectPrivilege EVENT
```
    Event MY_SQL object privilege.
  - EXECUTE
```
public static final MySqlObjectPrivilege EXECUTE
```
    Execute MY_SQL object privilege.
  - GRANT_OPTION
```
public static final MySqlObjectPrivilege GRANT_OPTION
```
    Grant option MY_SQL object privilege.
  - INDEX
```
public static final MySqlObjectPrivilege INDEX
```
    Index MY_SQL object privilege.
  - INSERT
```
public static final MySqlObjectPrivilege INSERT
```
    Insert MY_SQL object privilege.
  - LOCK_TABLES
```
public static final MySqlObjectPrivilege LOCK_TABLES
```
    Lock tables MY_SQL object privilege.
  - REFERENCES
```
public static final MySqlObjectPrivilege REFERENCES
```
    References MY_SQL object privilege.
  - SELECT
```
public static final MySqlObjectPrivilege SELECT
```
    Select MY_SQL object privilege.
  - SHOW_VIEW
```
public static final MySqlObjectPrivilege SHOW_VIEW
```
    Show view MY_SQL object privilege.
  - TRIGGER
```
public static final MySqlObjectPrivilege TRIGGER
```
    Trigger MY_SQL object privilege.
  - UPDATE
```
public static final MySqlObjectPrivilege UPDATE
```
    Update MY_SQL object privilege.
- Method Detail
  - values
```
public static MySqlObjectPrivilege[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
    for (MySqlObjectPrivilege c : MySqlObjectPrivilege.values()) System.out.println(c);
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static MySqlObjectPrivilege valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
    
    Parameters:
    
    name - the name of the enum constant to be returned.
    
    Returns:
    
    the enum constant with the specified name
    
    Throws:
    
    IllegalArgumentException - if this enum type has no constant with the specified name
    
    NullPointerException - if the argument is null
  - getSqlName
```
public default String getSqlName()
```
    Get a space-separated name of a privilege.
    
    Returns:
    
    privilege as a string
  - name
```
public abstract String name()
```
    Get a privilege name as it is.
    
    Returns:
    
    privilege as a string

Enum MySqlObjectPrivilege

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

ALTER

ALTER_ROUTINE

CREATE

CREATE_ROUTINE

CREATE_TEMPORARY_TABLES

CREATE_VIEW

DELETE

DROP

EVENT

EXECUTE

GRANT_OPTION

INDEX

INSERT

LOCK_TABLES

REFERENCES

SELECT

SHOW_VIEW

TRIGGER

UPDATE

Method Detail

values

valueOf

getSqlName

name