View projections are Cirro's implementation of row and column security. They allow the same view to return different data depending on who selects from them.

Syntax

ALTER VIEW viewname ADD PROJECTION viewprojection
AUTHENTICATED AS [user | role]
AS SELECT * FROM system.database.schema.table
ALTER VIEW viewname DROP PROJECTION viewprojection;

Arguments

Additional Information

  • The AUTHENTICATED AS section is optional

  • To grant access to the view projection use a GRANT SELECT command. For example:

GRANT SELECT ON hub.home.views."theview::proj"

See Also