The Database Access tab of the Login Properties window allows you to specify access on each Repository database. Use this tab if your environment requires permissions settings that tightly control database access. For example, you can deny access to the Repository databases by default, but grant a login access to a specific Repository database.

Select the Repository database on which you want to set permissions, and then select the appropriate permissions.

Your selections are applied along with any default permissions you set when you registered the corresponding SQL Server instance.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels