mysql

package
v3.82.6 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Sep 26, 2024 License: AGPL-3.0 Imports: 16 Imported by: 0

Documentation

Overview

Code generated by go generate; DO NOT EDIT.

Index

Constants

This section is empty.

Variables

View Source 
var (
	PermissionStrings = map[Permission]string{
		Alter:                      "alter",
		AlterRoutine:               "alter_routine",
		AllowNonexistentDefiner:    "allow_nonexistent_definer",
		ApplicationPasswordAdmin:   "application_password_admin",
		AuditAbortExempt:           "audit_abort_exempt",
		AuditAdmin:                 "audit_admin",
		AuthenticationPolicyAdmin:  "authentication_policy_admin",
		BackupAdmin:                "backup_admin",
		BinlogAdmin:                "binlog_admin",
		BinlogEncryptionAdmin:      "binlog_encryption_admin",
		CloneAdmin:                 "clone_admin",
		ConnectionAdmin:            "connection_admin",
		Create:                     "create",
		CreateRole:                 "create_role",
		CreateRoutine:              "create_routine",
		CreateTablespace:           "create_tablespace",
		CreateTemporaryTables:      "create_temporary_tables",
		CreateUser:                 "create_user",
		CreateView:                 "create_view",
		Delete:                     "delete",
		Drop:                       "drop",
		DropRole:                   "drop_role",
		EncryptionKeyAdmin:         "encryption_key_admin",
		Event:                      "event",
		Execute:                    "execute",
		File:                       "file",
		FirewallAdmin:              "firewall_admin",
		FirewallExempt:             "firewall_exempt",
		FirewallUser:               "firewall_user",
		FlushOptimizerCosts:        "flush_optimizer_costs",
		FlushStatus:                "flush_status",
		FlushTables:                "flush_tables",
		FlushUserResources:         "flush_user_resources",
		GrantOption:                "grant_option",
		GroupReplicationAdmin:      "group_replication_admin",
		GroupReplicationStream:     "group_replication_stream",
		Index:                      "index",
		InnodbRedoLogArchive:       "innodb_redo_log_archive",
		InnodbRedoLogEnable:        "innodb_redo_log_enable",
		Insert:                     "insert",
		LockingTables:              "locking_tables",
		MaskingDictionariesAdmin:   "masking_dictionaries_admin",
		NdbStoredUser:              "ndb_stored_user",
		PasswordlessUserAdmin:      "passwordless_user_admin",
		PersistRoVariablesAdmin:    "persist_ro_variables_admin",
		Process:                    "process",
		Proxy:                      "proxy",
		References:                 "references",
		Reload:                     "reload",
		ReplicationApplier:         "replication_applier",
		ReplicationClient:          "replication_client",
		ReplicationSlave:           "replication_slave",
		ReplicationSlaveAdmin:      "replication_slave_admin",
		ResourceGroupAdmin:         "resource_group_admin",
		ResourceGroupUser:          "resource_group_user",
		RoleAdmin:                  "role_admin",
		Select:                     "select",
		SensitiveVariablesObserver: "sensitive_variables_observer",
		ServiceConnectionAdmin:     "service_connection_admin",
		SessionVariablesAdmin:      "session_variables_admin",
		SetAnyDefiner:              "set_any_definer",
		SetUserId:                  "set_user_id",
		ShowDatabases:              "show_databases",
		ShowRoutine:                "show_routine",
		ShowView:                   "show_view",
		Shutdown:                   "shutdown",
		SkipQueryRewrite:           "skip_query_rewrite",
		Super:                      "super",
		SystemUser:                 "system_user",
		SystemVariablesAdmin:       "system_variables_admin",
		TableEncryptionAdmin:       "table_encryption_admin",
		TelemetryLogAdmin:          "telemetry_log_admin",
		TpConnectionAdmin:          "tp_connection_admin",
		TransactionGtidTag:         "transaction_gtid_tag",
		Trigger:                    "trigger",
		Update:                     "update",
		Usage:                      "usage",
		VersionTokenAdmin:          "version_token_admin",
		XaRecoverAdmin:             "xa_recover_admin",
	}

	StringToPermission = map[string]Permission{
		"alter":                        Alter,
		"alter_routine":                AlterRoutine,
		"allow_nonexistent_definer":    AllowNonexistentDefiner,
		"application_password_admin":   ApplicationPasswordAdmin,
		"audit_abort_exempt":           AuditAbortExempt,
		"audit_admin":                  AuditAdmin,
		"authentication_policy_admin":  AuthenticationPolicyAdmin,
		"backup_admin":                 BackupAdmin,
		"binlog_admin":                 BinlogAdmin,
		"binlog_encryption_admin":      BinlogEncryptionAdmin,
		"clone_admin":                  CloneAdmin,
		"connection_admin":             ConnectionAdmin,
		"create":                       Create,
		"create_role":                  CreateRole,
		"create_routine":               CreateRoutine,
		"create_tablespace":            CreateTablespace,
		"create_temporary_tables":      CreateTemporaryTables,
		"create_user":                  CreateUser,
		"create_view":                  CreateView,
		"delete":                       Delete,
		"drop":                         Drop,
		"drop_role":                    DropRole,
		"encryption_key_admin":         EncryptionKeyAdmin,
		"event":                        Event,
		"execute":                      Execute,
		"file":                         File,
		"firewall_admin":               FirewallAdmin,
		"firewall_exempt":              FirewallExempt,
		"firewall_user":                FirewallUser,
		"flush_optimizer_costs":        FlushOptimizerCosts,
		"flush_status":                 FlushStatus,
		"flush_tables":                 FlushTables,
		"flush_user_resources":         FlushUserResources,
		"grant_option":                 GrantOption,
		"group_replication_admin":      GroupReplicationAdmin,
		"group_replication_stream":     GroupReplicationStream,
		"index":                        Index,
		"innodb_redo_log_archive":      InnodbRedoLogArchive,
		"innodb_redo_log_enable":       InnodbRedoLogEnable,
		"insert":                       Insert,
		"locking_tables":               LockingTables,
		"masking_dictionaries_admin":   MaskingDictionariesAdmin,
		"ndb_stored_user":              NdbStoredUser,
		"passwordless_user_admin":      PasswordlessUserAdmin,
		"persist_ro_variables_admin":   PersistRoVariablesAdmin,
		"process":                      Process,
		"proxy":                        Proxy,
		"references":                   References,
		"reload":                       Reload,
		"replication_applier":          ReplicationApplier,
		"replication_client":           ReplicationClient,
		"replication_slave":            ReplicationSlave,
		"replication_slave_admin":      ReplicationSlaveAdmin,
		"resource_group_admin":         ResourceGroupAdmin,
		"resource_group_user":          ResourceGroupUser,
		"role_admin":                   RoleAdmin,
		"select":                       Select,
		"sensitive_variables_observer": SensitiveVariablesObserver,
		"service_connection_admin":     ServiceConnectionAdmin,
		"session_variables_admin":      SessionVariablesAdmin,
		"set_any_definer":              SetAnyDefiner,
		"set_user_id":                  SetUserId,
		"show_databases":               ShowDatabases,
		"show_routine":                 ShowRoutine,
		"show_view":                    ShowView,
		"shutdown":                     Shutdown,
		"skip_query_rewrite":           SkipQueryRewrite,
		"super":                        Super,
		"system_user":                  SystemUser,
		"system_variables_admin":       SystemVariablesAdmin,
		"table_encryption_admin":       TableEncryptionAdmin,
		"telemetry_log_admin":          TelemetryLogAdmin,
		"tp_connection_admin":          TpConnectionAdmin,
		"transaction_gtid_tag":         TransactionGtidTag,
		"trigger":                      Trigger,
		"update":                       Update,
		"usage":                        Usage,
		"version_token_admin":          VersionTokenAdmin,
		"xa_recover_admin":             XaRecoverAdmin,
	}

	PermissionIDs = map[Permission]int{
		Alter:                      1,
		AlterRoutine:               2,
		AllowNonexistentDefiner:    3,
		ApplicationPasswordAdmin:   4,
		AuditAbortExempt:           5,
		AuditAdmin:                 6,
		AuthenticationPolicyAdmin:  7,
		BackupAdmin:                8,
		BinlogAdmin:                9,
		BinlogEncryptionAdmin:      10,
		CloneAdmin:                 11,
		ConnectionAdmin:            12,
		Create:                     13,
		CreateRole:                 14,
		CreateRoutine:              15,
		CreateTablespace:           16,
		CreateTemporaryTables:      17,
		CreateUser:                 18,
		CreateView:                 19,
		Delete:                     20,
		Drop:                       21,
		DropRole:                   22,
		EncryptionKeyAdmin:         23,
		Event:                      24,
		Execute:                    25,
		File:                       26,
		FirewallAdmin:              27,
		FirewallExempt:             28,
		FirewallUser:               29,
		FlushOptimizerCosts:        30,
		FlushStatus:                31,
		FlushTables:                32,
		FlushUserResources:         33,
		GrantOption:                34,
		GroupReplicationAdmin:      35,
		GroupReplicationStream:     36,
		Index:                      37,
		InnodbRedoLogArchive:       38,
		InnodbRedoLogEnable:        39,
		Insert:                     40,
		LockingTables:              41,
		MaskingDictionariesAdmin:   42,
		NdbStoredUser:              43,
		PasswordlessUserAdmin:      44,
		PersistRoVariablesAdmin:    45,
		Process:                    46,
		Proxy:                      47,
		References:                 48,
		Reload:                     49,
		ReplicationApplier:         50,
		ReplicationClient:          51,
		ReplicationSlave:           52,
		ReplicationSlaveAdmin:      53,
		ResourceGroupAdmin:         54,
		ResourceGroupUser:          55,
		RoleAdmin:                  56,
		Select:                     57,
		SensitiveVariablesObserver: 58,
		ServiceConnectionAdmin:     59,
		SessionVariablesAdmin:      60,
		SetAnyDefiner:              61,
		SetUserId:                  62,
		ShowDatabases:              63,
		ShowRoutine:                64,
		ShowView:                   65,
		Shutdown:                   66,
		SkipQueryRewrite:           67,
		Super:                      68,
		SystemUser:                 69,
		SystemVariablesAdmin:       70,
		TableEncryptionAdmin:       71,
		TelemetryLogAdmin:          72,
		TpConnectionAdmin:          73,
		TransactionGtidTag:         74,
		Trigger:                    75,
		Update:                     76,
		Usage:                      77,
		VersionTokenAdmin:          78,
		XaRecoverAdmin:             79,
	}

	IdToPermission = map[int]Permission{
		1:  Alter,
		2:  AlterRoutine,
		3:  AllowNonexistentDefiner,
		4:  ApplicationPasswordAdmin,
		5:  AuditAbortExempt,
		6:  AuditAdmin,
		7:  AuthenticationPolicyAdmin,
		8:  BackupAdmin,
		9:  BinlogAdmin,
		10: BinlogEncryptionAdmin,
		11: CloneAdmin,
		12: ConnectionAdmin,
		13: Create,
		14: CreateRole,
		15: CreateRoutine,
		16: CreateTablespace,
		17: CreateTemporaryTables,
		18: CreateUser,
		19: CreateView,
		20: Delete,
		21: Drop,
		22: DropRole,
		23: EncryptionKeyAdmin,
		24: Event,
		25: Execute,
		26: File,
		27: FirewallAdmin,
		28: FirewallExempt,
		29: FirewallUser,
		30: FlushOptimizerCosts,
		31: FlushStatus,
		32: FlushTables,
		33: FlushUserResources,
		34: GrantOption,
		35: GroupReplicationAdmin,
		36: GroupReplicationStream,
		37: Index,
		38: InnodbRedoLogArchive,
		39: InnodbRedoLogEnable,
		40: Insert,
		41: LockingTables,
		42: MaskingDictionariesAdmin,
		43: NdbStoredUser,
		44: PasswordlessUserAdmin,
		45: PersistRoVariablesAdmin,
		46: Process,
		47: Proxy,
		48: References,
		49: Reload,
		50: ReplicationApplier,
		51: ReplicationClient,
		52: ReplicationSlave,
		53: ReplicationSlaveAdmin,
		54: ResourceGroupAdmin,
		55: ResourceGroupUser,
		56: RoleAdmin,
		57: Select,
		58: SensitiveVariablesObserver,
		59: ServiceConnectionAdmin,
		60: SessionVariablesAdmin,
		61: SetAnyDefiner,
		62: SetUserId,
		63: ShowDatabases,
		64: ShowRoutine,
		65: ShowView,
		66: Shutdown,
		67: SkipQueryRewrite,
		68: Super,
		69: SystemUser,
		70: SystemVariablesAdmin,
		71: TableEncryptionAdmin,
		72: TelemetryLogAdmin,
		73: TpConnectionAdmin,
		74: TransactionGtidTag,
		75: Trigger,
		76: Update,
		77: Usage,
		78: VersionTokenAdmin,
		79: XaRecoverAdmin,
	}
)
View Source 
var SCOPES = map[string]PrivTypes{

	"ALTER":                   {Global: true, Database: true, Table: true},
	"ALTER ROUTINE":           {Global: true, Database: true, Routine: true},
	"CREATE":                  {Global: true, Database: true, Table: true},
	"CREATE ROLE":             {Global: true},
	"CREATE ROUTINE":          {Global: true, Database: true},
	"CREATE TABLESPACE":       {Global: true},
	"CREATE TEMPORARY TABLES": {Global: true, Database: true},
	"CREATE USER":             {Global: true},
	"CREATE VIEW":             {Global: true, Database: true, Table: true},
	"DELETE":                  {Global: true, Database: true, Table: true},
	"DROP":                    {Global: true, Database: true, Table: true},
	"DROP ROLE":               {Global: true},
	"EVENT":                   {Global: true, Database: true},
	"EXECUTE":                 {Global: true, Database: true, Routine: true},
	"FILE":                    {Global: true},
	"GRANT OPTION":            {Global: true, Database: true, Table: true, Routine: true, Proxy: true},
	"INDEX":                   {Global: true, Database: true, Table: true},
	"INSERT":                  {Global: true, Database: true, Table: true, Column: true},
	"LOCK TABLES":             {Global: true, Database: true},
	"PROCESS":                 {Global: true},
	"PROXY":                   {Proxy: true},
	"REFERENCES":              {Global: true, Database: true, Table: true, Column: true},
	"RELOAD":                  {Global: true},
	"REPLICATION CLIENT":      {Global: true},
	"REPLICATION SLAVE":       {Global: true},
	"SELECT":                  {Global: true, Database: true, Table: true, Column: true},
	"SHOW DATABASES":          {Global: true},
	"SHOW VIEW":               {Global: true, Database: true, Table: true},
	"SHUTDOWN":                {Global: true},
	"SUPER":                   {Global: true},
	"TRIGGER":                 {Global: true, Database: true, Table: true},
	"UPDATE":                  {Global: true, Database: true, Table: true, Column: true},

	"USAGE": {Global: true, Database: true, Table: true, Column: true, Routine: true},

	"ALLOW_NONEXISTENT_DEFINER":    {Global: true, Dynamic: true},
	"APPLICATION_PASSWORD_ADMIN":   {Global: true, Dynamic: true},
	"AUDIT_ABORT_EXEMPT":           {Global: true, Dynamic: true},
	"AUDIT_ADMIN":                  {Global: true, Dynamic: true},
	"AUTHENTICATION_POLICY_ADMIN":  {Global: true, Dynamic: true},
	"BACKUP_ADMIN":                 {Global: true, Dynamic: true},
	"BINLOG_ADMIN":                 {Global: true, Dynamic: true},
	"BINLOG_ENCRYPTION_ADMIN":      {Global: true, Dynamic: true},
	"CLONE_ADMIN":                  {Global: true, Dynamic: true},
	"CONNECTION_ADMIN":             {Global: true, Dynamic: true},
	"ENCRYPTION_KEY_ADMIN":         {Global: true, Dynamic: true},
	"FIREWALL_ADMIN":               {Global: true, Dynamic: true},
	"FIREWALL_EXEMPT":              {Global: true, Dynamic: true},
	"FIREWALL_USER":                {Global: true, Dynamic: true},
	"FLUSH_OPTIMIZER_COSTS":        {Global: true, Dynamic: true},
	"FLUSH_STATUS":                 {Global: true, Dynamic: true},
	"FLUSH_TABLES":                 {Global: true, Dynamic: true},
	"FLUSH_USER_RESOURCES":         {Global: true, Dynamic: true},
	"GROUP_REPLICATION_ADMIN":      {Global: true, Dynamic: true},
	"GROUP_REPLICATION_STREAM":     {Global: true, Dynamic: true},
	"INNODB_REDO_LOG_ARCHIVE":      {Global: true, Dynamic: true},
	"INNODB_REDO_LOG_ENABLE":       {Global: true, Dynamic: true},
	"MASKING_DICTIONARIES_ADMIN":   {Global: true, Dynamic: true},
	"NDB_STORED_USER":              {Global: true, Dynamic: true},
	"PASSWORDLESS_USER_ADMIN":      {Global: true, Dynamic: true},
	"PERSIST_RO_VARIABLES_ADMIN":   {Global: true, Dynamic: true},
	"REPLICATION_APPLIER":          {Global: true, Dynamic: true},
	"REPLICATION_SLAVE_ADMIN":      {Global: true, Dynamic: true},
	"RESOURCE_GROUP_ADMIN":         {Global: true, Dynamic: true},
	"RESOURCE_GROUP_USER":          {Global: true, Dynamic: true},
	"ROLE_ADMIN":                   {Global: true, Dynamic: true},
	"SENSITIVE_VARIABLES_OBSERVER": {Global: true, Dynamic: true},
	"SERVICE_CONNECTION_ADMIN":     {Global: true, Dynamic: true},
	"SESSION_VARIABLES_ADMIN":      {Global: true, Dynamic: true},
	"SET_ANY_DEFINER":              {Global: true, Dynamic: true},
	"SET_USER_ID":                  {Global: true, Dynamic: true},
	"SHOW_ROUTINE":                 {Global: true, Dynamic: true},
	"SKIP_QUERY_REWRITE":           {Global: true, Dynamic: true},
	"SYSTEM_USER":                  {Global: true, Dynamic: true},
	"SYSTEM_VARIABLES_ADMIN":       {Global: true, Dynamic: true},
	"TABLE_ENCRYPTION_ADMIN":       {Global: true, Dynamic: true},
	"TELEMETRY_LOG_ADMIN":          {Global: true, Dynamic: true},
	"TP_CONNECTION_ADMIN":          {Global: true, Dynamic: true},
	"TRANSACTION_GTID_TAG":         {Global: true, Dynamic: true},
	"VERSION_TOKEN_ADMIN":          {Global: true, Dynamic: true},
	"XA_RECOVER_ADMIN":             {Global: true, Dynamic: true},
}

https://dev.mysql.com/doc/refman/8.0/en/grant.html#grant-global-privileges:~:text=%27localhost%27%3B-,Privileges%20Supported%20by%20MySQL,-The%20following%20tables

Functions

func AnalyzeAndPrintPermissions added in v3.80.5 

func AnalyzeAndPrintPermissions(cfg *config.Config, key string)

Types

type Analyzer added in v3.82.2 

type Analyzer struct {
	Cfg *config.Config
}

func (Analyzer) Analyze added in v3.82.2 

func (a Analyzer) Analyze(_ context.Context, credInfo map[string]string) (*analyzers.AnalyzerResult, error)

func (Analyzer) Type added in v3.82.2 

func (Analyzer) Type() analyzerpb.AnalyzerType

type Column 

type Column struct {
	Name  string
	Privs []string
}

type Database 

type Database struct {
	Name        string
	Default     bool
	Tables      *[]Table
	Privs       []string
	Routines    *[]Routine
	Nonexistent bool
}

type GlobalPrivs 

type GlobalPrivs struct {
	Privs []string
}

type Permission added in v3.82.2 

type Permission int
const (
	Invalid                    Permission = iota
	Alter                      Permission = iota
	AlterRoutine               Permission = iota
	AllowNonexistentDefiner    Permission = iota
	ApplicationPasswordAdmin   Permission = iota
	AuditAbortExempt           Permission = iota
	AuditAdmin                 Permission = iota
	AuthenticationPolicyAdmin  Permission = iota
	BackupAdmin                Permission = iota
	BinlogAdmin                Permission = iota
	BinlogEncryptionAdmin      Permission = iota
	CloneAdmin                 Permission = iota
	ConnectionAdmin            Permission = iota
	Create                     Permission = iota
	CreateRole                 Permission = iota
	CreateRoutine              Permission = iota
	CreateTablespace           Permission = iota
	CreateTemporaryTables      Permission = iota
	CreateUser                 Permission = iota
	CreateView                 Permission = iota
	Delete                     Permission = iota
	Drop                       Permission = iota
	DropRole                   Permission = iota
	EncryptionKeyAdmin         Permission = iota
	Event                      Permission = iota
	Execute                    Permission = iota
	File                       Permission = iota
	FirewallAdmin              Permission = iota
	FirewallExempt             Permission = iota
	FirewallUser               Permission = iota
	FlushOptimizerCosts        Permission = iota
	FlushStatus                Permission = iota
	FlushTables                Permission = iota
	FlushUserResources         Permission = iota
	GrantOption                Permission = iota
	GroupReplicationAdmin      Permission = iota
	GroupReplicationStream     Permission = iota
	Index                      Permission = iota
	InnodbRedoLogArchive       Permission = iota
	InnodbRedoLogEnable        Permission = iota
	Insert                     Permission = iota
	LockingTables              Permission = iota
	MaskingDictionariesAdmin   Permission = iota
	NdbStoredUser              Permission = iota
	PasswordlessUserAdmin      Permission = iota
	PersistRoVariablesAdmin    Permission = iota
	Process                    Permission = iota
	Proxy                      Permission = iota
	References                 Permission = iota
	Reload                     Permission = iota
	ReplicationApplier         Permission = iota
	ReplicationClient          Permission = iota
	ReplicationSlave           Permission = iota
	ReplicationSlaveAdmin      Permission = iota
	ResourceGroupAdmin         Permission = iota
	ResourceGroupUser          Permission = iota
	RoleAdmin                  Permission = iota
	Select                     Permission = iota
	SensitiveVariablesObserver Permission = iota
	ServiceConnectionAdmin     Permission = iota
	SessionVariablesAdmin      Permission = iota
	SetAnyDefiner              Permission = iota
	SetUserId                  Permission = iota
	ShowDatabases              Permission = iota
	ShowRoutine                Permission = iota
	ShowView                   Permission = iota
	Shutdown                   Permission = iota
	SkipQueryRewrite           Permission = iota
	Super                      Permission = iota
	SystemUser                 Permission = iota
	SystemVariablesAdmin       Permission = iota
	TableEncryptionAdmin       Permission = iota
	TelemetryLogAdmin          Permission = iota
	TpConnectionAdmin          Permission = iota
	TransactionGtidTag         Permission = iota
	Trigger                    Permission = iota
	Update                     Permission = iota
	Usage                      Permission = iota
	VersionTokenAdmin          Permission = iota
	XaRecoverAdmin             Permission = iota
)

func PermissionFromID added in v3.82.2 

func PermissionFromID(id int) (Permission, error)

PermissionFromID converts an ID to its Permission enum

func PermissionFromString added in v3.82.2 

func PermissionFromString(s string) (Permission, error)

PermissionFromString converts a string representation to its Permission enum

func (Permission) ToID added in v3.82.2 

func (p Permission) ToID() (int, error)

ToID converts a Permission enum to its ID

func (Permission) ToString added in v3.82.2 

func (p Permission) ToString() (string, error)

ToString converts a Permission enum to its string representation

type PrivTypes 

type PrivTypes struct {
	Global   bool
	Database bool
	Table    bool
	Column   bool
	Routine  bool
	Proxy    bool
	Dynamic  bool
}

type Routine 

type Routine struct {
	Name        string
	Privs       []string
	Nonexistent bool
}

type SecretInfo added in v3.80.5 

type SecretInfo struct {
	Host        string
	User        string
	Databases   map[string]*Database
	GlobalPrivs GlobalPrivs
}

func AnalyzePermissions 

func AnalyzePermissions(cfg *config.Config, connectionStr string) (*SecretInfo, error)

type Table 

type Table struct {
	Name        string
	Columns     []Column
	Privs       []string
	Nonexistent bool
	Bytes       uint64
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.