Spanner/SpanSQL: Support CREATE VIEW with Security Type DEFINER #8661
Description
Client
Spanner spansql
Environment
Go Playground
Go Environment
Go 1.21
Code
package main
import (
"fmt"
"cloud.google.com/go/spanner/spansql"
)
func main() {
fmt.Println(spansql.ParseDDL("ddl", "CREATE VIEW myView SQL SECURITY DEFINER AS SELECT u.Name FROM Users u"))
}
https://go.dev/play/p/x_tUX5Iv8-a
Expected behavior
Parses
Actual behavior
<nil> ddl:1.32: got "DEFINER" while expecting "INVOKER"
Documentation
The security type can be either INVOKER or DEFINER