Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    2

    Question Unanswered: How to allow only one application to sql server at a time.

    If we use windows authentication using MS-SQL, apart from the pb application, excel and other apps are also connected to the DB. How to restrict this.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    sp_setapprole should do the trick. Grant all nessary permissions to the role, then revoke all superfluous permissions from the users and their roles.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    May 2009
    Posts
    2

    How to allow only one application to sql server at a time?

    Hi Pat phelan,

    Thanks for ur help, i ll try it and get back....

    Thanks,
    SentamilSelvan.G
    Last edited by sentamilselvan; 05-07-09 at 03:53.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •