grant_access

NAME

grant_access(): Grant SELECT & EXECUTE to all grantees on common_schema

TYPE

Procedure

DESCRIPTION

This is a common_schema meta routine, which grants access on common_schema to all existing accounts.

It will, in particular, grant SELECT and EXECUTE on all tables, views and routines in common_schema.

You may possibly wish to execute this routine after common_schema installation so as to allow all accounts access to common_schema.

SYNOPSIS

grant_access() 
  MODIFIES SQL DATA

ENVIRONMENT

MySQL 5.1 or newer

SEE ALSO

duplicate_grantee(), processlist_grantees, sql_accounts

AUTHOR

Shlomi Noach
 
common_schema documentation