Re: Grant access to applications only



Hi,

Give a try to "application roles".

--
Rubén Garrigós
Solid Quality Mentors

"ulrich schumacher" <ulrichschumacher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:8C26EF26-CC8C-4907-8E13-0F380A059394@xxxxxxxxxxxxxxxx
Hi all!

Is there a way to allow a .net application write access to sql server but
to
deny a direct user login e.g. via management studio.

The background is that the users must not be able to manipulate the data
directly but only within the application. Integrated security should be
used
as authentication type.

Thanks in advance
Ulrich



.



Relevant Pages

  • Re: Grant access to applications only
    ... but to deny a direct user login e.g. via management studio. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Grant access to applications only
    ... but to deny a direct user login e.g. via management studio. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)