Explanation: USER_NAME or CURRENT_USER Return the database user name. 2. Point out the correct statement :
A. Implementing row level security based on security labels is possible in SQL Server 2008
B. A security label is a marking that describes the securable content of an item
C. Row-level permissions are used for applications that store information in a single table.
D. None of the mentioned
Answer:A
Explanation: USER_NAME or CURRENT_USER Return the database user name. 2. Point out the correct statement :
A. Implementing row level security based on security labels is possible in SQL Server 2008 B. A security label is a marking that describes the securable content of an item C. Row-level permissions are used for applications that store information in a single table. D. None of the mentioned
Explanation:SQL Server does not have support for implementing row-level security. You must create additional columns in your tables that define row filtering mechanisms. 3. View that contains the list of all the security labels present in the database :