Re: Need Urgent Help...............

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 07:36:32 -0000

Have a look at Application Roles in BOL. By activating an application role
from your application and by only granting permissions to that application
role, you should be able to get the behaviour you require 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Manish Mokadam" <manish.mokadam@honeywell.com> wrote in message
news:471E447A-D6B2-4361-8814-AF59362FA34D@microsoft.com...
> Hi i  am manish,working wth sql server2000
>
> Need Urgent Help...............
>
> Currently,we are preparing our one software,
> I want to enfore some security check ,so that user of that software not
able to watch what kind of data that software contains
>
> security i need for that
>
> 1) application level: no other external software are allowed
>
> 2)default Windows NT groups are  to be disable
>
> 3) user should able to execute any kind select ,etc query
>
>
> Regards
> Manish

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting to the bottom of MSDE network connection problems ...
    ... Brilliant, Nick, especially the explanation for local network user being ... authenticated as GUEST in WinXP SP2. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ... > again and selected the security tab. ...
    (microsoft.public.sqlserver.msde)
  • [NT] SQL Extended Procedure Functions Contain Unchecked Buffers
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... SQL Server 7.0 and 2000 provide extended stored procedures, ... Several of the Microsoft-provided extended stored procedures have been ... Exploiting the flaw could enable an attacker to either cause the SQL ...
    (Securiteam)
  • RE: Login failed for user (null).
    ... used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ...
    (microsoft.public.dotnet.framework.aspnet.security)