The database objects in the SPL program can be referenced by using either a qualified name or an unqualified name.
The form of a qualified name is schema.name, in which schema specifies the name of the schema for a database object and name specifies the name of the database object. An unqualified name does not contain the "schema." portion. If a qualified name is used, the database object is precisely specified. In the specified schema, the object either exists or does not exist.
SHOW search_path; Search_path ---------------------- $ User, public, sys, dbo (1 row)
In this example, $user is a placeholder that refers to the current user. If the current user in the preceding session is polardb, a database object with an unqualified name is searched in order in the following schemas: polardb, public, sys, and dbo.
When an unqualified database object is parsed in the search path, the system checks whether the current user is authorized to perform the corresponding operations on the specified object.