var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Granting permission for a VIEW - totally confused!
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?
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.
Thanks MCrowley for your help. How would I give the database user permission to select from a VIEW in SQL Server?
Replace the italics with the view name, and the username.
grant select on viewname to username