Results 1 to 4 of 4
  1. #1
    Join Date
    May 2010
    Posts
    67

    Unanswered: Granting permission for a VIEW - totally confused!

    Hello,

    I have an application, the front end is Access and the back end is sql server 2008 express.

    The application does not display the view on a user's machine. Do I have to grant permission for the user, in order for the VIEW to display?

    I have tried granting permission, but I am doing something wrong. Please help!

    Where do I start?

    PLEASE HELP!!!!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Typically, if a database user has permission to select from a view, they will see it show up in a listing. If not, it will be hidden from them.

  3. #3
    Join Date
    May 2010
    Posts
    67
    Thanks MCrowley for your help. How would I give the database user permission to select from a VIEW in SQL Server?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Code:
    grant select on viewname to username
    Replace the italics with the view name, and the username.

Posting Permissions

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