The invention provides a static
authentication method capable of aiming at
SQL (Structured
Query Language) analytical query. The method comprises the following steps of: S1: obtaining the
SQL analytical query submitted by a user; S2: constructing a genealogical tree from the
SQL analytical query; S3: on the basis of the genealogical tree, extracting a
data access request of the SQL analytical query; and S4: on the basis of an
access control rule, authenticating the
data access request. Compared with an existing
database access control technology, the static
authentication method combines the characteristics of the analytical query to support simultaneous access to a plurality of columns and control for an operation. Therefore, by use of the method, the SQL analytical query can be more flexibly and accurately authenticated. Meanwhile, by use of the method, an administrator is permitted to carry out permission management through the compiling of the
access control rule, in addition, no extra burdens are brought to users, and therefore, the static
authentication method exhibits better availability. Finally, the method carries out authentication only on the basis of the SQL analytical query, so that an authentication process is more efficient, and the method is suitable for a large-scale
data analysis scene.