Table permission vs query permissions

Is it possible to deny a person/group direct access to tables in a DB, but
allow them to access the data in the tables through a query or stored
procedure?

This way, I can make the query accessible to other client applications for
reporting purposes (like Access, Excel, PowerPoint, etc).

I need users to be able to access the data they need to see but not give
anyone direct access to the tables. The idea is to have queries that are
accessible as data sources (at least in the users view).


Thanks,

Jacques


.

Relevant Pages

  • HELP! Query a Custom List
    ... I need to query a custom list or I need formula help for a view on the custom ... As for the development environment. ... I do no have direct access to the server. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Access: Protect data in tables from copy and export...
    ... Say that user NO has no direct access to table T, ... User NO will not be able to run this query, under any circumstances, afaik: ... If you add WITH OWNERACCESS OPTION, ... OPTION query, he is delegating his read authority to table T, to owner NO, ...
    (microsoft.public.access.forms)
  • Re: Downloading from a directory not in the servers path?
    ... you can protect the files from direct access by adding in your ... Deny from all ... Say you wanna protect all the files with the .ext extension. ...
    (comp.lang.php)
  • Re: Column level security
    ... have the query return values for the columns not denied ... DENY ... >> Have assigned select perm to a table and deny perm to a ... When admin ran query, got all columns. ...
    (microsoft.public.sqlserver.security)
  • Re: Column level security
    ... > column without modifing query. ... DENY doesn't "substitute" values ... can be cut and pasted into Query Analyzer is appreciated. ... When admin ran query, got all columns. ...
    (microsoft.public.sqlserver.security)