You are the administrator of a SQL Server system that contains a database named Accounting. To maintain strict security on the database, you want to make sure users do not have any default permissions when their account is first created. What should you do?

You are the administrator of a SQL Server system that contains a database named Accounting. To maintain strict security on the database, you want to make sure users do not have any default permissions when their account is first created. What should you do?

You are the administrator of a SQL Server system that contains a database named Accounting. To maintain strict security on the database, you want to make sure users do not have any default permissions when their account is first created. What should you do?


Answer: – Execute the REVOKE ALL FROM PUBLIC command in Query Editor while using your database.

(Users cannot be removed from the public role, which has every permission granted by default. The easiest way to remove these permissions is with the REVOKE ALL FROM PUBLIC command.)