locked
Database access for "Just Programmatically" RRS feed

  • Question

  • Dear experts;


    I am newbie in SQL Server.


    I am building a new database for a test program.


    And I don't want to directly access from other users directly to my database. So; an user or Administrator will not access directly to my database. But my program will always connect the Database and works with SP, Triggers, Transaction, etc ... I will use that database for a commercial packages. And database security is important for me : Table structures, Trriggers, Stored Procedures etc.. ( Some Views can be accessable from other users )


    I know, i will define a powered user ( for programmaticaly access - ) but how will i keep my database from other peoples, users or system administrators.


    In summary, I would like access to database from with in the only my program.

    Is that possible? If yes what is the way?

    Thank you in advance for your answers and comments

    • Edited by Ugur_YILMAZ Monday, January 18, 2010 1:59 PM
    Monday, January 18, 2010 1:30 PM

Answers


  • I think; so based on your reply,  I will try crypt some fields and Stored Procedures;

    Best wishes.


    Encrypting data columns will provide security.

    Encrypting sprocs will not work - a number of decrypting software available for free download.
    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    • Marked as answer by Ugur_YILMAZ Monday, January 18, 2010 2:57 PM
    Monday, January 18, 2010 2:13 PM

All replies

  • You cannot keep a DBA (system administrator) away from your database.


    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Monday, January 18, 2010 1:59 PM
  • Thanks for fast reply;

    I think; so based on your reply,  I will try crypt some fields and Stored Procedures;

    Best wishes.

    Monday, January 18, 2010 2:08 PM

  • I think; so based on your reply,  I will try crypt some fields and Stored Procedures;

    Best wishes.


    Encrypting data columns will provide security.

    Encrypting sprocs will not work - a number of decrypting software available for free download.
    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    • Marked as answer by Ugur_YILMAZ Monday, January 18, 2010 2:57 PM
    Monday, January 18, 2010 2:13 PM
  • I think an idea for smart securitiy :


    1. Some fields will include metadata for me. And I will define that fields nVarCharMax and I will Crpyt that content of field. Just in my program that fields content will be view correctly

    2. I will Use all Stored Procedures and Triggers by Encryption option.

    These methods may be adequete for particular security?

    Best wishes.
    Monday, January 18, 2010 2:30 PM