[ORACLE] GRANT / CREATE / ALTER / SHOW / REVOKE

SHOW { TABLE [ tablename | viewname ] | INDEX [ tablename ] | TRIGGER [ tablename ] | STATUS | DATABASE | USER }

DESC { tablename | viewname }

CREATE DATABASE { dbname }

DROP DATABASE { dbname }

CREATE USER id password [ SUPERUSER ]

DROP USER id

ALTER USER id SET { PASSWORD newpassword | [ NO ]SUPERUSER }

GRANT { ALL | SELECT | INSERT | UPDATE | DELETE | ALTER | TRIGGER | SHOW } ON { dbname.tablename | dbname.* | *.* | * } TO { username | PUBLIC }

GRANT CREATE { ALL | TABLE | VIEW | INDEX | TRIGGER } ON { dbname | * } TO { username | PUBLIC }

REVOKE { ALL | SELECT | INSERT | UPDATE | DELETE | ALTER | TRIGGER | SHOW } ON { dbname.tablename | dbname.* | *.* | * } TO { username | PUBLIC }

REVOKE CREATE { ALL | TABLE | VIEW | INDEX | TRIGGER } ON { dbname | * } TO { username | PUBLIC }