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

    Monday, January 18, 2010 1:27 PM