Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    162

    Unanswered: allow access to 1 view only

    What is the best and simplest way to give access to only 1 view to a remote system?

    I have a remote reports system that need access to my SQL. They only need access to 1 view at my sql to retrive their data.

    They login with their account using TCP/IP connection and a local SQL account

    What role, access should i give the account, etc?

    The SQL is SQL2008 standard 64-bits



    thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    First, lock down the "Public" role so that it has no database access.
    Then, create a role that has only read access to the specific view you mention. Assign your users to this role.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2004
    Posts
    162
    thanks, i manage to do this and it seems to work just fine exepct that when i connect to db i can see the sys tables (and can export them) and i guess i have not been able to lockdown public role correctly... How should i lockdown public role?

    edit: it seems like i need to get access to the tables that the view uses?! How to solve this?



    //Mr
    Last edited by mrpcguy; 10-26-10 at 08:35.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can either open up the security permissions on each of those objects and revoke Public's privileges, or you can open up the Public role's privileges and rescind privileges on the system objects.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Have you considered not giving them access at all and opting for other delivery methods? Do they NEED access to the view in real time?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  6. #6
    Join Date
    Dec 2010
    Posts
    1
    some times it is necesary that they have real time access , teddy

Posting Permissions

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