What are the commands of a Superuser?

Asked

Viewed 25 times

-1

I would like to know what are the Rights that a Superuser has within a database.

  • He can make what changes?
sql postgresql

1 answer

0


Privilege Description ALL [PRIVILEGES] All privileges except GRANT OPTION

  • ALTER Lets you run ALTER TABLE
  • CREATE Lets you run CREATE TABLE
  • CREATE TEMPORARY TABLES Allows to execute CREATE TEMPORARY TABLE
  • DELETE Lets you run DELETEbold text
  • DROP Lets you run DROP TABLE
  • EXECUTE Allows running stored procedures (Mysql 5.0)
  • FILE Allows to execute SELECT ... INTO OUTFILE and LOAD DATA INFILE
  • INDEX Allows to execute CREATE INDEX and DROP INDEX
  • INSERT Allows to execute INSERT
  • LOCK TABLES Allows you to run LOCK TABLES on tables that you have the SELECT privilege
  • PROCESS Allows to run SHOW FULL PROCESSLIST
  • REFERENCES Not yet implemented
  • RELOAD Lets run FLUSH
  • REPLICATION CLIENT Allows the user to obtain the Master or Slave location
  • REPLICATION SLAVE Required for Slave replication (reading Master binary log events)
  • SELECT Lets you run SELECT
  • SHOW DATABASES displays all databases
  • SHUTDOWN Lets you run mysqladmin shutdown
  • SUPER Allows you to run CHANGE MASTER, KILL , PURGE MASTER LOGS and SET GLOBAL. Allows connecting to the server once, even if max_connections has been reached
  • UPDATE Allows running UPDATE
  • USAGE Synonym for "no privileges''
  • GRANT OPTION Allows the user to pass on their privileges

Browser other questions tagged sql postgresql

You are not signed in. Login or sign up in order to post.