restrict user with db_owner access RRS feed

  • Question

  • Hi,

    Here is the requirement, one vendor tool needed db_owner access to SQL server its a technical requirement from tools end.

    i can provide this access but, i want to restrict that SQL login to be used from SQL authentication or from ssms apart from tool.

    so that no one can access our sensitive data from vendor end?

    or after providing db_wner accesss to a user can i still restrict him to access tables of some specific schema?

    SQL Server DBA

    Wednesday, November 20, 2019 11:41 AM

All replies