What can you use to limit users to see only 2018 data?

A view with a filter is the appropriate method for limiting users to see only specific data, such as data from the year 2018. This approach involves defining a view that incorporates a filter condition based on the desired criteria, allowing users to access only the rows of data that meet this criterion. For instance, a SQL statement can be constructed within the view to specify that only entries from the year 2018 should be included. This ensures that when users query the view, they are presented exclusively with filtered data relevant to that year, thereby providing a clear and straightforward way to control the visibility of data.

Using a view with a restricted column, while possibly helpful in some scenarios, does not inherently limit the data displayed based on specific criteria like a date; rather, it restricts visibility of certain fields or columns. Object privileges manage what actions users can perform on various database objects but do not filter the data itself. SQL analytic privileges allow for more complex data accessibility rules but are generally used for defining row-level security rather than filtering views based on explicit conditions like a specific year. Therefore, using a view with a filter is the most effective and direct method for achieving the goal of displaying only 2018 data to users.