Re: Table permission vs query permissions

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

  • Re: different environment fails to fill a dataset
    ... successfully ran the select command with no problems. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: different environment fails to fill a dataset
    ... Well I recreated the login but it didn't make any difference. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: problem to connect sql server 2005 from localhost (W2k3)
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... It's possible to connect the sql server via telnet? ...
    (microsoft.public.sqlserver.connect)
  • Re: limit connections option
    ... individual users or dbs within a single SQL Server app. ... > Thanx Andrew, is there any other way or tools to limit data trasnfer. ... >> Andrew J. Kelly SQL MVP ... >>> This is a shared server with 150 databases belonging to different ...
    (microsoft.public.sqlserver.tools)
  • Re: different environment fails to fill a dataset
    ... can't access the SQL Server and the Resources winform can access SQL Server ... They both work fine on my development workstation. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)