locked
Sql Server Security RRS feed

  • Question

  • Hi Developed a windows application with sql server I want to secure my database file so the other peoples should not access my tables and stored procedures

    Is it posssible to achieve security using sql authentication (if the database file is copied and attached to other system it should not work) if so help me to achieve it 

    I heard that we can apply sql encryption for our database so help me to achieve it

    Thanks In advance
    Sathish Kumar Devan
    Wednesday, September 30, 2009 12:01 PM

Answers

  • Hello,

    Have a look at this thread, they are talking about Protect Database With Password.

    Have a nice day, thanks!


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Proposed as answer by Lekss Tuesday, October 6, 2009 12:23 AM
    • Marked as answer by Alex Feng (SQL) Tuesday, October 13, 2009 2:53 AM
    Friday, October 2, 2009 6:19 AM

All replies

  • http://msdn.microsoft.com/en-us/library/bb934049.aspx
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, September 30, 2009 2:46 PM
  •   It sounds like you are really looking for Digital Rights Management (DRM) for SQL Server objects. SQL Server does not provide such infrastructure. For more detailed information look for other links that have "DRM" keyword.

    I hope this information helps.

      -Raul Garcia
       SDE/T
       SQL Server Engine


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, October 1, 2009 8:57 PM
  • Hello,

    Have a look at this thread, they are talking about Protect Database With Password.

    Have a nice day, thanks!


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Proposed as answer by Lekss Tuesday, October 6, 2009 12:23 AM
    • Marked as answer by Alex Feng (SQL) Tuesday, October 13, 2009 2:53 AM
    Friday, October 2, 2009 6:19 AM