Post reply

How to prevent access with TDE ... one user wants to access on the fly.

  • May 9, 2020 at 5:54 am

    #3750114

    if we want ensure no one else access database and only app user can get connect. Please suggest options to use on the fly / network along with data need to encrypt.....

  • May 9, 2020 at 8:11 am

    #3750124

    Please elaborate on your question. We don't know your system. Is it a web application? A fat Windows client? And what do you mean with the second sentence?

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • May 9, 2020 at 8:26 am

    #3750126

    Yes, Its web application and required only one user can get connect to database with TDE. Please suggest how to set / configure the access at database level.....

    Thanks.

  • May 9, 2020 at 8:33 am

    #3750127

    If it is a web application that uses an application login, don't add users as logins to SQL Server at all. If  you already have, drop them.

    TDE requires nothing special - T stands for "transaparent".

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply