Re: Table permission vs query permissions

I appreciate the help.

Thank you,

Jacques

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:O1VeS$1VHHA.4076@xxxxxxxxxxxxxxxxxxxxxxx
That is a common and basically recommended way to give access in sql
server. Tkae a look in BooksOnLine under security, Grant, Deny etc.

--
Andrew J. Kelly SQL MVP

"Jacques" <Jacques Latoison at hotmail dot com> wrote in message
news:ua7UZM1VHHA.4404@xxxxxxxxxxxxxxxxxxxxxxx
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